Dan McCullough wrote: > I want to show a default piece of information if my query returns no > result, and what I mean by no result is the query for a store in a certain > state doesnt exist.
http://php.net/mysql_num_rows (Or sybase_num_rows, or odbc_num_rows, or whatever your database is.) If 0 rows were returned, you print your message. <?php if (mysql_num_rows($result) == 0){ echo "No stores found"; } ?> -- Like music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]