Returning Stored Procedure Results
Okay... I've tried a million (okay, maybe a dozen) different techniques to try and get this stored procedure to work and I've failed every time. I'm passing a unique id into the stored procedure and want to get back the corresponding results when the logic is finished.
For example, I have:
I had no problem doing just one of the variable sets as I could do a SELECT and get all of the results back, but we need to do all three at once so that we're not having to reconnect from PHP each time. Any suggestions?