Hi Its not much tuff. you have to close the connection and restart the mysql connection before call stored procedure; because you must be using normal array method or either php variables. you should use Class with auto constructor method or function overlading when you want to call multiple stored procedure from same database/table schema. so better idea, close the mysql connection every stored procedure execution end and put mysql connection start before stored procedure starts. hope, you understand the problem why? Thanks, Muthukumar Selvarasu, Project Manager (Web Development), Webmaster Ltd. _____ From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of malayappa@xxxxxxxxxxxxxxxxxx Sent: Monday, December 10, 2007 4:25 PM To: php-objects@xxxxxxxxxxxxxxx Cc: malayapp@xxxxxxxxxxxxxxxxxx Subject: facing problem when calling multiple stored procdures of mysql from php Hi We are working on php and mysql database.We are actually implementing stored procedures in the functions in the php.When we try to call multiple stored procedures within the same php we are able to get the results.But when we try to call multiple stored procedures through functions,we are able to call the first stored procedure and it is returning values,but unable to call the second one(stored procedure).It is showing warning message.We tried in forums but didn't got any solution. Thanks & Regards Srinivas PMM [Non-text portions of this message have been removed]
