note 41757 added to function.mysql-free-result

From: Date: Wed, 21 Apr 2004 18:41:16 +0000
Subject: note 41757 added to function.mysql-free-result
Groups: php.notes 
Request: Send a blank email to php-notes+get-68467@lists.php.net to get a copy of this message
Hi, I have this code: // When function is invoked by a Dynamically set Site, then clear on-line table $result = mysql_query( "select staticupdate from $prefix"._msanalysis_admin." where id='1'" ); list( $staticupdate ) = mysql_fetch_row( $result ); if( ! $staticupdate ) { // Delete all records from table msanalysis_online mysql_query( "OPTIMIZE TABLE $prefix"._msanalysis_online); $result = mysql_query( "DELETE QUICK FROM $prefix"._msanalysis_online); mysql_free_result($result); mysql_query("OPTIMIZE TABLE $prefix"._msanalysis_online); } } And when I run it it gives me the following error: Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /path/to/root/file.php on line 319 Does anybody know what is the reason of this error? Thank you. ---- Manual Page -- http://www.php.net/manual/en/function.mysql-free-result.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+41757 Delete -- http://master.php.net/manage/user-notes.php?action=delete+41757&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+41757&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#68467) next »