SP first time in mySQL
Posted: Wed Jan 26, 2011 9:31 am
Hi, I have written SP in SQL Server with .NET but this is my first time with mySQL and php -
Basically the SP takes one paramater which basically is querystring value - for instance - www.abc.com/def.php?name=testing
so i call sp from my php script as -
CALL xyz($name);
(Where xyz is sp name and $name is querystring value - testing in this case)
Finally am fetching the array to $member in sp and my question is how to return this result to php page from mysql sp ?
I hope this make sense.
thanks
Basically the SP takes one paramater which basically is querystring value - for instance - www.abc.com/def.php?name=testing
so i call sp from my php script as -
CALL xyz($name);
(Where xyz is sp name and $name is querystring value - testing in this case)
Finally am fetching the array to $member in sp and my question is how to return this result to php page from mysql sp ?
I hope this make sense.
thanks