Bug #13946 Updated: mysql_free_result giving error for valid $result

From: Date: Tue, 06 Nov 2001 14:45:33 +0000
Subject: Bug #13946 Updated: mysql_free_result giving error for valid $result
References: 1  Groups: php.dev 
Request: Send a blank email to php-dev+get-69695@lists.php.net to get a copy of this message 
ID: 13946
Updated by: jpm
Reported By: rohan.hawthorne@nt.gov.au
Old Status: Duplicate
Status: Bogus
Bug Type: MySQL related
Operating System: Red Hat Version 2.4
PHP Version: 4.0.4pl1
New Comment:

User submitted bug several times by accident (wasn't this fixed ?)

Not a bug -> bogus

--Joao

Previous Comments:
------------------------------------------------------------------------

[2001-11-05 22:35:11] rohan.hawthorne@nt.gov.au

Here is the code:

$SQL = "UPDATE tblAsset SET fldAssetId = 2, fldAssetCode = 'bc04495' WHERE fldAssetId
= 2";
$result = mysql_query("$SQL");
if (!$result) { echo("ERROR: " . mysql_error() . "$SQL");   }
mysql_free_result ($result);

Here is the error:
Warning: Supplied argument is not a valid MySQL result resource in
/var/www/html/itss/ProcessAsset.php on line 3

If an UPDATE doesn't produce a positive $result, why does the first error check not produce an
error ?

------------------------------------------------------------------------



Edit this bug report at http://bugs.php.net/?id=13946&edit=1

Thread (3 messages)

« previous php.dev (#69695) next »