Maybe
if (!($result)) {
Try
print STDERR "RESULT=$result\n";
to see what you are comparing to.
Chris Hohimer wrote:
> 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
