You might want to use:

mysql_num_rows <function.mysql-num-rows.html> -- Get number of rows in result

Stuart Felenstein wrote:

I want to send back a message when no matches are
found on my search page. Basically "No matches
found". I assumed that mysql_fetch_assoc would be the
determining factor on whether any rows will come back.
As you can see below I do a if ($row_rsCS == false). Apparently though (while the message is sharp and
centered ;)), it is not to right place, since it sends
the message and exits whether records / matches exist
or not. Any suggestions ?

Thank you Stuart

$query_limit_rsCS = sprintf("%s LIMIT %d, %d",
$query_rsCS, $startRow_rsCS, $maxRows_rsCS);
$rsCS = mysql_query($query_limit_rsCS, $Pmmodel) or
$row_rsCS = mysql_fetch_assoc($rsCS);

if ($row_rsCS == false)
<p align="center"><strong><?php print_r ("No Matches
Found"); ?> </strong></p>

//print_r($row_rsCS); if (isset($_GET['totalRows_rsCS'])) { $totalRows_rsCS = $_GET['totalRows_rsCS']; } else { $all_rsCS = mysql_query($query_rsCS); $totalRows_rsCS = mysql_num_rows($all_rsCS); } $totalPages_rsCS = ceil($totalRows_rsCS/$maxRows_rsCS)-1;

Reply via email to