example mysql_connect("database connection") or die ("could not connect"); mysql_select_db("database name") or die (mysql_error()); $sql=mysql_query("SELECT * FROM table"); $result=mysql_fetch_array($sql) echo $result; to retrieve data in php and mysql. --- On Tue, 11/11/08, birgunj birgunj <birgunjp0071@xxxxxxxxx> wrote: From: birgunj birgunj <birgunjp0071@xxxxxxxxx> Subject: how to use mysql stored procedure in php To: phpexperts@xxxxxxxxxxxxxxx, talk@xxxxxxxxxxxxxxx Cc: php_group@xxxxxxxxxxxxxxx, phpworld@xxxxxxxxxxxxxxx Date: Tuesday, 11 November, 2008, 11:36 AM Dear All, i want to use mysql stored procedure in my program.but i did not know how to use it in php.for example in php we execute the query like mysql_query( "select * from table").then fetch the row like this $row =mysql_fetch_ array($sql) . i need help in stored procedure,how can retrive the value and call the stored procedure in php. if any body has any idea or tutorial or book please share with us. thanks humayoo [Non-text portions of this message have been removed] New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/ [Non-text portions of this message have been removed]