Re: eof bof in php

On Sun, 2008-12-21 at 15:22 +0000, Gary Maddock-Greene wrote: > 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 > > Can you not just use the $totalRows_rsSearch value inside of an if statement? Ash www.ashleysheridan.co.uk