CORRECTION to: DB: throwing error with mysql.trace_mode = On , "2 result set(s) not freed..." - same error every time $db-> is called

From: 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/

« previous php.pear.general (#20921) next »