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