Re: Where to handle no results

At 00:09 04/07/00 -0400, you wrote:

That gave me a "Fatal error: Cannot break from 1 loop(s) from nesting level 0" Heading back to the drawing board. ;-) -- Ian Evans

count total record with your condituon if result < 1 that mean you dont have any record i.e $gottotal = mysql_query( "SELECT Count(*) as total FROM $table where ....write down your condition here") or die(mysql_error()); $row1=mysql_fetch_Array($gottotal); $total=$row1[total]; if ( $total < 1 ) { echo "no record" } else { echo"data found $total" }