MySQL Forums
Forum List  »  PHP

php call stored procedure
Posted by: alan shen
Date: December 25, 2005 02:03PM

Hi,

I have a very simple sp, like:

select * from t_table;

I call it like :

$sql="call sp_simple";

$ds=mysql_query($sql);

when I use $dr=mysql_fetch_array($ds);

I got error like:mysql_fetch_array(): supplied argument is not a valid MySQL result resource ,

it seems I can use select in stored procedure,

Please help me out of the simple problem!!!!


Thanks in advance!!!

alan

Options: ReplyQuote


Subject
Written By
Posted
php call stored procedure
December 25, 2005 02:03PM
December 25, 2005 05:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.