calling stored procedure from php

[btkaruna]

hi,

Created storedprocedure and executing it at mysql , its working fine.but the same when i am calling from php its giving error.following is the error that i am facing

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result

$query="call getRandRegID(@RegID)";
$result = mysql_query($query, $conn) or die ( mysql_error() );
$row = mysql_fetch_row($result);
$rid=$row[0];
echo $rid;

plz. help me how to solve this issue

Thanks in advance
karuna

[NogDog]

I believe you have to use the [man]mysqli[/man] extension, using [man]mysqli_real_query[/man] in order to call a MySQL stored procedure (or possibly the [man]PDO[/man] functions, instead).