MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: PHP Commands out of sync, you can't run this command now
Posted by: Hartmut Holzgraefe
Date: September 30, 2008 07:16AM

A stored procedure may return more than one result set and it will always return one extra result set that does not contain any data but the overall error/warning information about the procedure call in addition to any explicitly returned result sets.

A new query can only be issued on a connection after *all* pending results have been fetched, so to process procedure CALL results you need to use mysqli_next_result()/mysqli_more_results() as shown in the example on

http://php.net/mysqli_multi_query

--
Hartmut Holzgraefe, MySQL Regional Support Manager EMEA

Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
PHP Commands out of sync, you can't run this command now
Rahul Dubal
September 29, 2008 09:11PM
Re: PHP Commands out of sync, you can't run this command now
Hartmut Holzgraefe
September 30, 2008 07:16AM
Re: PHP Commands out of sync, you can't run this command now
Peter Brawley
September 30, 2008 08:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.