eof bof in php
| From: | Gary Maddock-Greene | Date: | Sun, 21 Dec 2008 15:22:39 +0000 |
| Subject: | eof bof in php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-284913@lists.php.net to get a copy of this message | ||
Hi, I'm very new to php. Please can someone point me in the right direction? I want to display a message: 'No Products Found' if my search record set returns no value.
I think I need to be looking at this section of my code ...
$query_rsSearch = sprintf("SELECT * FROM products WHERE product_name LIKE
%s", GetSQLValueString("%" . $colname_rsSearch . "%", "text"));
$rsSearch = mysql_query($query_rsSearch, $sondia_lighting) or
die(mysql_error());
$row_rsSearch = mysql_fetch_assoc($rsSearch);
$totalRows_rsSearch = mysql_num_rows($rsSearch);
?>
Thanks
- Gary Maddock-Greene