PHP mysql stored procedure execution problem

[vibra narayanan]

hi all

i am having problem with executing stored procedure with php any one please advice me


I have to use php 4.3.10 and mysql 5.0.4


i am using below SP and PHP script.Please advice me


SP
create procedure helloprocedure()
begin
select 'Hello Procedure 2' ;
end


PHP Script


<?php
$link = mysql_connect('localhost', 'root', '1234',);
if (!$link) { die('Could not connect: ' . mysql_error()); }
echo 'Connected successfully';
$qry=mysql_query("call helloprocedure()") or die(mysql_error());
$rs=mysql_fetch_object($qry);
print_r($rs);
?>


Please advice me