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;
       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 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 (
To unsubscribe, visit:

Reply via email to