|
Posted by Curt Zirzow on 02/08/05 05:45
* Thus wrote Ian Porter:
> Hi,
>
> I am just wondering how to obtain the result from a mysql procedure OUT
> parameter within PHP e.g.
>
> MYSQL
> create procedure test_out(OUT testvar int)
> BEGIN
> select max_connections into testvar from mysql.user limit 1;
> END
>
> PHP
>
> $query = 'call test_out('.$test_val.')';
> $query_handle = mysql_query($query);
You should really be using the mysqli* interface to mysql. It
provides better ways to execute things like that.
http://php.net/mysqli
Curt
--
Quoth the Raven, "Nevermore."
Navigation:
[Reply to this message]
|