Re: php - no results - display other message

From: "Chris Dowell" <php@nodalplane.com>

Or alternatively $result = mysql_query("SELECT * FROM tablename"); if (mysql_num_rows($result)) { while ($row = mysql_fetch_row($result)) { // display results } } else echo "No results";

bah... you're wasting precious resources on a mysql_num_rows call... ;) $result = mysql_query(" ... "); if($row = mysql_fetch_assoc($result)) { do{ //display results }while($row=mysql_fetch_assoc($result)); } else { echo 'No results'; } Millions ways to do it. :) ---John Holmes...