Re: Re: Passing by conditional IF statement...why?
| From: | Ryan A | Date: | Tue, 23 Mar 2004 01:58:09 +0000 |
| Subject: | Re: Re: Passing by conditional IF statement...why? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-181219@lists.php.net to get a copy of this message | ||
> "Ryan A" <ryan@coinpass.com> wrote in message
>
news:000301c4106e$f4ddf390$f081aa51@l2zcaxu7emppqh...
> > Hi,
> > I have this simple code in my php script:
> >
> > * * * * *
> > $res = mysql_query("SELECT product_id, now()-1
> FROM ".$tc."_prods where
> > cno=$cno AND product_id='$product_id' LIMIT 1");
> >
> > if($res)
> > {
> > $r = mysql_fetch_row($res);
> > $product_id2 = $r[0];
> > $th_pres= $r[1];
> > echo "debug echo";
> > }else {echo "No results, sorry";}
> > * * * * *
> >
> > its working great when the data actually exists
> but when there are no
> > matches it still executes the "if($res)" part
> instead of
> > displaying "No results, sorry".
> > Why is that? or am I using the syntax wrong?
> >
> > Thanks,
> > -Ryan
Thanks guys,
I'm now using:
if(($r = mysql_fetch_row($res)) >=1)
and its working fine, if the above approach has some problems, feel free to
write and tell me.
Cheers,
-Ryan