Hi Humayoo, I was surprised to see a lack of responses on the list I'm subbed to... For MSSQL, you would want mssql_init(): http://us.php.net/manual/en/function.mssql-init.php See also: http://www.devarticles.com/c/a/PHP/Executing-SQL-Server-Stored- Procedures-With-PHP/3/ It's a bit trickier when it comes to MySQL, but this will get you there: http://www.macronimous.com/resources/ using_stored_procedure_with_mySQL_and_PHP.asp MySQL didn't have stored procedures until v5, and for PHP to really catch up it may be a while. Most servers I deal with still use PHP 4. *shrug* -- Joe On Nov 12, 2008, at 4:07 AM, birgunj birgunj wrote: > Dear All, > > i want to use 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]
