Re: [PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

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; >> E

Re: [PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

* 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

[PHP] PHP/5.0.3 & MySQL 5.0.2 Stored procedure (OUT)

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_quer