hitech123

Thanks Mikosiko, u r right too. Actually i solved this issue last night. I added following function in the class. function ClearRecordsets(){ //mysqli_free_result($this->result); while(mysqli_next_result($this->dbh)){ if($l_result = mysqli_store_result($this->dbh)){ mysqli_free_result($l_result); } } } Now it's working perfect.

well, i guess you guys love tackling syntax error issues with less than 10 lines php codes only.......if you have looked at the code at least for 30 secs you'd have understood the problem. The problem is with "mysqli_fetch_object". If we go through an object oriented way the error shows in the 2nd query.

Hello, We have large queries and we have decided to use a stored procedure of MYSQL. The attached sql.php was made using mysql function of mysql, but for using stored procedure, i just changed all mysql function to mysqli. The code is working fine except that we are getting "Command out of sync." error. We get this error when first query to execute stored procedure follows another query to execute stored procedure or even simple sql query. We have made a research on the error and we understood that this error comes when the resultsets are not freed. But as i go through class we have freed mysqli results wherever necessary. We dont know what is causing the error, We had worked on the project for 6 months so we can't change everything but the sql.php. Any help will be much appreciated. Regards Анил Шарма [attachment deleted by admin]