trouble calling a stored procedure within php.

[raz0r]

I am not sure if implemented the procedure wrong on the php end or mysql end.

I have this simple procedure

Procedure check (OUT A CHAR)
BEGIN
 SELECT "good" AS A;
END

I call this directy in mysql console and get the result "good" under table "A";


In my php, I have

...
$r = mysql_query("CALL check());

$r2 = mysql_result($r,0);

echo $r2; 

I get this error :

"PROCEDURE check can't be return a result set in the given context"

[virtualdevl]

You forgot some quotes:

$r = mysql_query("call check()"); 

[raz0r]

nope not the quotes, It's there in my original