thanks for all the replies!! but it is not working. here is the loop: if($result == EMPTY SET){ $Scheduled = NULL; } else{ $Tech = mysql_result($result, 0, "tech"); $SNumber = mysql_result($result, 0, "snumber"); $Scheduled = mysql_result($result, 0, "scheduled"); }
here is what i've tried and the results #1. if ($result == NULL){ Warning Unable to jump to row 0 on MySQL result index# in Location-of-file.php line 158 #2. if (is_null($result)){ SAME #3. if ($result == 'NULL'){ SAME #4. if($result){ WORKS but it executes the $Scheduled= NULL code on everything. even when there are actual results that are not empty set. Any more suggestions? thanks Chris Hohimer Sandia National Labs CSU821 ORG9623 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php