Posted by Marlin Forbes on 09/29/65 12:00

Ratfish wrote:
> root user record to establish a connection. I'm essentially opening a
> connection at the top of the php page and then calling multiple stored
> procedures to fetch data. When I call the 2nd stored procedure I'm
> getting the error. Any info would be greatly appreciated.

Hi Ratfish,

I think you must free the resultsets from the stored procedures before
opening another one. Look at mysql_free_result if you're using the mysql
extension, or mysqli_stmt_free_result if using the mysqli extension.

Regards,
Marlin Forbes
Data Shaman
datashaman.com

[Back to original message]