Re: Question: For no results

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); //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;