Question: For no results
| From: | Stuart Felenstein | Date: | Fri, 03 Dec 2004 14:38:39 +0000 |
| Subject: | Question: For no results | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37547@lists.php.net to get a copy of this message | ||
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;