Return reseultset from stored procedure???
Posted: Wed Jul 15, 2009 1:59 pm
I have a stored procedure it works great, but when I run it in phpMyAdmin or PHP I do not get any results.
I have added an outgoing parameter BUT it doesn't appear that resultsets can be returned from a procedure or function as arrays are not supported. I asked a fellow co-worker and he suggested I look into creating a temp table to dump results into then pull from that temp table?
I"m Googling but have not been able to find anything complete, can someone explain the steps and/or show actual SQL and PHP code on how this might be done -- probably the SQL_SP code more than anything, thanks
Cheers,
Alex
I have added an outgoing parameter BUT it doesn't appear that resultsets can be returned from a procedure or function as arrays are not supported. I asked a fellow co-worker and he suggested I look into creating a temp table to dump results into then pull from that temp table?
I"m Googling but have not been able to find anything complete, can someone explain the steps and/or show actual SQL and PHP code on how this might be done -- probably the SQL_SP code more than anything, thanks
Cheers,
Alex