If you're using PHP5, you should use PDO to wrap this for you :- http://uk3.php.net/manual/en/pdo.prepared-statements.php Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of birgunj birgunj Sent: 11 November 2008 03:37 To: phpexperts@xxxxxxxxxxxxxxx; talk@xxxxxxxxxxxxxxx Cc: php_group@xxxxxxxxxxxxxxx; phpworld@xxxxxxxxxxxxxxx Subject: how to use mysql stored procedure in php 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] ------------------------------------ Are you looking for a PHP job? Join the PHP Professionals directory Now! http://www.phpclasses.org/professionals/Yahoo! Groups Links *********************************************************************************** Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient or entity to whom they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Random House Group + 44 (0) 20 7840 8400 http://www.randomhouse.co.uk http://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.uk Generic email address - enquiries@xxxxxxxxxxxxxxxxx Name & Registered Office: THE RANDOM HOUSE GROUP LIMITED 20 VAUXHALL BRIDGE ROAD LONDON SW1V 2SA Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 ***********************************************************************************