Stored Procedure that returns multiple result sets

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
aditya.fx
Forum Newbie
Posts: 1
Joined: Fri Jun 05, 2009 8:27 am

Stored Procedure that returns multiple result sets

Post by aditya.fx »

Hi,

I am using MySQLi_STMT class to execute a stored procedure from my database.
The problem is that my procedure returns multiple result sets and I am able to access only the first using MySQLi_STMT::result_metadata.

I can retrieve data from multiple result sets if I use MySQLi::multi_query and then by MySQLi::next_result().

Is there any way I can do this using MySQLi_STMT?

Thanks In Advance.
Post Reply