Thanks to everyone that replied. After trying solutions from everyone and still not getting it to work I finally figured out why my code:
$result = mysql_query($query,$connection) or die("Error in Query"); $num = mysql_num_rows($result); if ($num == 0) echo something; else echo something else; was not working. I had that piece of code in a while ($row = mysql_fetch_array($result)) loop. It seems that if there is nothing to get the condition inside the while loop is false so my code above was never being executed. Even when I tried printing out the contents of $num it would always be blank. The clue came when I deliberately changed the vale of $num right above my code above and it still didn't work. Thanks again to all who replied. It was a good chance to learn about isset(), empty() and other functions. Frank Frank Miller Computer Specialist and Webmaster Technology and Distance Education Texas A&M University-Texarkana 2600 North Robison Rd Texarkana, Texas 75501 Phone: 903-223-3156 Fax: 903-223-3139 Office: 165 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php