communicating with mysql5 stored procedures

Greetings!

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.

The SQL-Statement

CALL sp_get_values()

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.

Many thanks!

re: communicating with mysql5 stored procedures

cieletmer wrote:[color=blue]
> Greetings!
>
> 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.
>
> The SQL-Statement
>
> CALL sp_get_values()
>
> 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.
>
> Many thanks!
>[/color]

You need to use the "MySQL Improved Extension" for features of mysql 4.1
and above...

http://us3.php.net/mysqli

--
Justin Koivisto, ZCE - justin@koivi.com
http://koivi.com

re: communicating with mysql5 stored procedures

Thanks, Justin!

Ciao,

Ciel&Mer

re: communicating with mysql5 stored procedures

Justin Koivisto wrote:[color=blue]
> You need to use the "MySQL Improved Extension" for features of mysql 4.1
> and above...
>
> http://us3.php.net/mysqli
>[/color]

Or PDO?

http://us3.php.net/pdo

Kevin N.

re: communicating with mysql5 stored procedures

Kevin Newman wrote:[color=blue]
> Justin Koivisto wrote:
>[color=green]
>> You need to use the "MySQL Improved Extension" for features of mysql
>> 4.1 and above...
>>
>> http://us3.php.net/mysqli
>>[/color]
>
> Or PDO?
>
> http://us3.php.net/pdo[/color]

Which is a pear library & uses mysqli - IINM

--
Justin Koivisto, ZCE - justin@koivi.com
http://koivi.com