[PHP] eof bof in php

[Gary Maddock-Greene]

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 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php