----- Original Message -----
From: "Chris Hohimer" <[EMAIL PROTECTED]>
To: "Anil Garg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 2:26 PM
Subject: Re: help with empty set
> yeah that kinda works...
>
> what i have is
>
> $result = mysql($database "select x, y, z from $table where a and b and
> c;", $link);
> if ($result == empty set){
I think it shoudl work if u replace the above line with
if ($result){
Plz write back the results
> $z = NULL;
> }
> else
> $x = mysql_result($result, 0, "x");
> $y= mysql_result($result, 0, "y");
> $z = mysql_result($result, 0, "z");
> }
>
> i have 1 row in my table. this row contains legit values for a, b, and c
> so
> when i set $result to NULL or 0 or whatever it goes into the ELSE
> statement
> but when select returns "Empty Set (0.02 sec)" it gives me this:
>
> Warning: Unable to jump to row 0 on MySQL result index# in
> Location-of-file.php
>
> On Wednesday, June 5, 2002, at 12:20 PM, Anil Garg wrote:
>
> > have u tried with \0 ??
> > ----- Original Message -----
> > From: "Chris Hohimer" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 05, 2002 1:54 PM
> > Subject: help with empty set
> >
> >
> >> using PHP what is the value for a returned result from MySQL of "empty
> >> set"
> >> ex:
> >>
> >> if($result != NULL){
> >> do this
> >> }
> >> else{
> >> do that
> >> }
> >>
> >> but NULL is not right. what should I replace NULL with?
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> 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
> >>
> >
>
>
---------------------------------------------------------------------
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
