|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2005-04-29 03:08 UTC] sales at girderboot dot com
[2005-05-03 09:18 UTC] georg@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 27 02:00:01 2025 UTC |
Description: ------------ After executing a query using a stored procedure that returns a result set, no futher queries can be executed. SProc's that don't return a result set, or embedded SQL queries are not affected (but even they still cannot run after a SP with a result set is run.) MySQL and PHP both version 5.0.4 Reproduce code: --------------- $db = new mysqli('localhost','xxx','xxx','campnet'); if (!$exec = $db->query("CALL Acct_Bal(1)")) echo $db->error; $balance = $exec->fetch_row(); $exec->close(); echo $balance[0]; echo "<BR>"; // Second Time if (!$exec = $db->query("CALL Acct_Bal(1)")) echo $db->error; $balance = $exec->fetch_row(); $exec->close(); echo $balance[0]; Expected result: ---------------- Should Output the same result Twice (In this case, the accout balance): 0.00 0.00 Actual result: -------------- 0.00 Lost connection to MySQL server during query Fatal error: Call to a member function fetch_row() on a non-object in C:\Program Files\Apache Group\Apache2\htdocs\driver.php on line 40