Re: 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; >> 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