I still don't understand why you need to do it this way. Are you using the mysqli client library for the statements? This support the mysqli_prepare() method, which will allow you to send multiple queries over a single connection? Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Vijaya Lakshmi Sent: 21 December 2007 10:52 To: php-objects@xxxxxxxxxxxxxxx Subject: RE: Calling multiple stored procedures. Hi, thank you for your message.Actually if we not closed the connection we unable to called the next stored procedure.So that every time we have done open and close the connection to mysql "Atkinson, Robert" <ratkinson@xxxxxxxxxxxxx> wrote: Why do you think you need to open and close the connection in-between calls to the stored procedure? -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of emandi govind rao Sent: 21 December 2007 08:55 To: php-objects@xxxxxxxxxxxxxxx Subject: Calling multiple stored procedures. Hi All, We have written code for multiple functions in php.In the functions we are using stored procedures calls.First we called a stored procedure,retrived values.To retrive values from second stored porcedure we need to close the previously opened connection and then execute the second stored procedure. But actually we are using remote MYSQL DB.Due to the closing/opening of DB connection ,it is taking so much to execute our application. We need an alternaive method to avoid close/open connection each time for each strored procedure call. If any one knows a solution, please help us. Thanking u all. ***************************************************************************** ****** 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 ***************************************************************************** ****** --------------------------------- Download prohibited? No problem. CHAT from any browser, without download. --------------------------------- Forgot the famous last words? Access your message archive online. Click here. [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
