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);
//print_r($query_limit_rsCS);
$rsCS = mysql_query($query_limit_rsCS, $Pmmodel) or
die(mysql_error());
//print_r($rsCS);
$row_rsCS = mysql_fetch_assoc($rsCS);
if ($row_rsCS == false)
?>
<p align="center"><strong><?php print_r ("No Matches
Found"); ?> </strong></p>
<?php
exit;
//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;
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
