RE: [PHP] Table shows even when if () is false
| From: | Jay Blanchard | Date: | Wed, 22 Aug 2007 21:17:59 +0000 |
| Subject: | RE: [PHP] Table shows even when if () is false | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-261133@lists.php.net to get a copy of this message | ||
[snip]
$deferred_comments= "SELECT * FROM comments WHERE credit_card_id =
'$credit_card_id' AND request_type = 'D'";
$result_deferred_comments = mssql_query($deferred_comments) or
die(mssql_error());
if(!empty($result_deferred_comments)) {
[/snip]
$result_deferred_comments is not empty, a query resource was returned.
To see this;
echo $result_deferred_comments;
What you want to do is something like this;
$num_Deferred_Comments = mysql_num_rows($result_deferred_comments);
if(0 != $num_Deferred_Comments)) {....