note 41757 rejected from function.mysql-free-result by betz

From: Date: Wed, 21 Apr 2004 18:46:58 +0000
Subject: note 41757 rejected from function.mysql-free-result by betz
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-68469@lists.php.net to get a copy of this message
Note Submitter: radicadoenmiami@hotmail.com ---- 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.

« previous php.notes (#68469) next »