Posted by Ian Porter on 02/08/05 21:49

Curt Zirzow wrote:

> * 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

Thanks very much, that did the trick.

Cheers
Ian
>
>
> Curt

[Back to original message]