In nearly every database (specifically Oracle and MS SQLServer), you can encompass multiple select statements within one stored procedure (it's actually VERY common from the database side).
The ODBC API has a function called SQLMoreResults that allows you to move to the next "cursor" (recordset) within that procedure, if one exists, of course.
I don't know much about PHP, but is there a built-in function or a way to access the next recordset (not the next row) from that database procedure?
Any suggestions would be GREATLY appreciated with this problem. Thanks.
