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

From: Date: Tue, 06 Nov 2001 14:57:27 +0000
Subject: Bug #13945 Updated: mysql_free_result giving error for valid $result
References: 1  Groups: php.dev 
Request: Send a blank email to php-dev+get-69698@lists.php.net to get a copy of this message
ID: 13945 Updated by: jpm Reported By: rohan.hawthorne@nt.gov.au Old Status: Open 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:34:52] 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 produce an error ? ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=13945&edit=1

« previous php.dev (#69698) next »