从php调用MySQL存储过程的问题

Question

I have a stored MySQL procedure that takes a customer number and a currency as input. It outputs an array using a select statement. The output array is comprised of Balance and NetBalance,

If I call the procedure from MySQL as "call GetAccountBalanceByCurrency(500,'USD')" I get the correct results.

However, if I call it from PHP as $x= mysqli_multi_query("call GetAccountBalanceByCurrency(500,'USD');"), I get the following error message:

Warning: mysqli_multi_query() expects exactly 2 parameters, 1 given 
    in C:\...\...\call_proc_test4.php on line 4. 

I assume it is something simple, but have been banging my head for hours. I have tried $x= mysqli_multi_query("call GetAccountBalanceByCurrency(500,'USD')"); among other things. Can anybody see the error?

Many thanks.

Answer 1

Check out the documentation for mysqli_multi_query. The way you're calling it needs two arguments instead of just the one:

http://us3.php.net/mysqli_multi_query