List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 6 2002 1:43pm
Subject:Re: still not-empty set
View as plain text  
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
>
>


Thread
still not-empty setChris Hohimer5 Jun
  • Re: still not-empty setGerald Clark6 Jun