Passing by conditional IF statement...why?
| From: | Ryan A | Date: | Tue, 23 Mar 2004 00:37:00 +0000 |
| Subject: | Passing by conditional IF statement...why? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-181202@lists.php.net to get a copy of this message | ||
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