MySQL - Stored procedure with multiple result sets

Question

Am using two select statements in a stored procedure but it is returning only single select statement table,how to get the both tables record set please suggest me?

Answer 1

Here is an example on how it is done in c.

EDIT:
Here is an example on how it is done in php

Answer 2

Make sure you are using the mysqli extension in php to be able to get multiple result resources from stored procedures - the standard PHP mysql interface doesn't support it.

This seems like a pretty good introduction to the class, especially:

First thing’s first, you shouldn’t treat calls to stored procedures which return a resultset as you would normal SQL queries. The reason being is that when executed, a stored procedure will give you two resultsets back. One with the actual resultset and another which sends the status of the stored procedure (OK/ERR).

Answer 3

union keyword? It is hard to answer without query.