Given the code below, how can I display the content of mysql_fetch_assoc array? What I would like to present is a list up to say 10 or 20 or all at a time of the matches that were found then display them as link where the user can simply click on it to display the content of the record.
Let's use a good existing code given by cxr for example:
Thanks in advance
$res = mysql_query(
"select * from $tablename where
firstname like '$firstname%' and
lastname like '$lastname%' and
department like '$department%'
order by id");
$row = mysql_fetch_assoc($res);
$row_count = mysql_num_rows($res);
if($row_count > 1) $msg = $row_count.' rows found, showing the first';
} else $msg = 'No rows found';
} else $msg = 'query failed: '.mysql_error();