note 41757 added to function.mysql-free-result
| From: | radicadoenmiami at hotmail dot com | 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