CORRECTION to: DB: throwing error with mysql.trace_mode = On , "2 result set(s) not freed..." - same error every time $db-> is called
| From: | l Burnerheimerton | Date: | Mon, 12 Sep 2005 13:16:09 +0000 |
| Subject: | CORRECTION to: DB: throwing error with mysql.trace_mode = On , "2 result set(s) not freed..." - same error every time $db-> is called | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-20921@lists.php.net to get a copy of this message | ||
I wanted to correct my previous post.
That error meesage occurs every time I use $db->
whether it's to get data for staic display or with
Quickform. For example:
$res =& $db->query("SELECT ...");
$prhS = $db->prepare("SELECT ...where l_ID = ?");
$prhR = $db->prepare("SELECT ...where m_ID = ?");
while($r =& $res->fetchRow()) {
$resS = $db->execute($prhS, $r[0]);
$resR = $db->execute($prhR, $r[0]);
...
}
Throws:
Warning: (null)(): 3 result set(s) not freed. Use
mysql_free_result to free result sets which were
requested using mysql_query() in Unknown on line 0
It throws that error EVEN IF I have $db->disconnect();
at the bottom of the page.
______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/