RE: [PHP] Passing by conditional IF statement...why?
| From: | Martin Towell | Date: | Tue, 23 Mar 2004 00:39:23 +0000 |
| Subject: | RE: [PHP] Passing by conditional IF statement...why? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-181205@lists.php.net to get a copy of this message | ||
Ryan
Because you are actually getting a result, a result with no records...
Might be better to use
http://au2.php.net/manual/en/function.mysql-num-rows.php
instead
Martin
> -----Original Message-----
> From: Ryan A [mailto:ryan@coinpass.com]
> Sent: Tuesday, 23 March 2004 11:37 AM
> To: php-general@lists.php.net
> Subject: [PHP] Passing by conditional IF statement...why?
>
>
> 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