Description: ------------ I had some trouble today looping the results of MDB2::executeStoredProc() using MySQLi. I eventually got it to work using the pattern in the test script section. This example may be useful to add to the result documentation at http://pear.php.net/manual/en/package.database.mdb2.intro-fetch.php. If you use the normal looping pattern, which is just the internal while loop, the result set will not be properly freed for MySQLi procedures. This causes out-of-sync errors when you call more than one procedure. This behavior may be a bug, in which case the test script is merely a workaround. Test script: --------------- $rs = $db->executeStoredProcedure('procedureName', array('argument1')); do { while ($row = $rs->fetchRow(MDB2_FETCHMODE_OBJECT)) { var_dump($row); } } while ($rs->nextResult());

This bug has been fixed in SVN. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.