Thank you very much for you message. we are new to php .So we know few concepts .We don't know entire php .So please give us a sample application with 2 to 3 functions thank u in advance.. vijaya "Atkinson, Robert" <ratkinson@xxxxxxxxxxxxx> wrote: I'd convert this to a class, if it's not already. You can then do something like :- $db = new MyDatabase(); $db->connect(...connection params...); $db->prepare("myquery1",$paramsArray); $db->execute(); $db->prepare("myquery2",$paramsArray); $db->execute(); $db->prepare("myquery3",$paramsArray); $db->execute(); $db->close(); In the 'execute' method, you could check to see if '$this->connected === true', and if not, you could either fail or try and connect using default parameters. You can also do something similar to this using procedural programming and global variables instead. Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Vijaya Lakshmi Sent: 21 December 2007 11:36 To: php-objects@xxxxxxxxxxxxxxx Subject: RE: Calling multiple stored procedures. Yes ,We are using mysqli library.We are using 19 functions in the same php page .Please check out following sample function which we are written in our application and please give us your suggestions. *********************************************************************************** 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 *********************************************************************************** --------------------------------- Bollywood, fun, friendship, sports and more. You name it, we have it. [Non-text portions of this message have been removed]