return result set in SPs

[Manu]

while connecting to Mysql you need to give the parameter CLIENT_MULTI_RESULTS,


mysql_real_connect ( &mysql,"192.168.1.4", "root", "root",NULL,
3310, NULL, CLIENT_MULTI_RESULTS );


Once you executes a query like, call sp_name(), it may return multiple resultset, you can extract these results as follows,
do{
...
result = mysql_store_result ( &mysql );
...
} while ( mysql_next_result ( &mysql ) <= 0 );