Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- communicating with mysql5 stored procedures
November 9, 2005, 5:01 pm
rate this thread
Does anyone have examples on how to interact with mysql5 stored
procedures from php?
I have a stored procedure sp_get_values() with last line
SELECT v_computed_value1 AS cv1, v_computed_value2 AS CV2 ;
When I try to call this from php with the lines:
$sql = "CALL sp_get_values()" ;
$query_result = mysql_query($sql, $connection) ;
the return value of mysql_query is FALSE and I can't do anything with
the mysql_fetch_* functions.
works fine with mysql directly and returns the expected 1 row with 2
columns cv1 and cv2.
While we're on the topic, examples of accessing mysql's OUT parameters
from PHP would also be great.