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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
