I have a php script that processes database mysql integration and will know if the queries fail and can handle those in the php script where the dbase queries are located. However, users of the application (when no mysql errors occur) will submit the page to continue to another function of the application which is on another page. On the new called page there may be errors related to another part of the application and if these occur the information written to the dbase in the previous calling page will need to be rolled back as they are no longer accurate and leaving them in the dbase will create a dbase integrity problem that will cause many errors in a dynamically updated web site. I need to call the commit() after getting to the new called page after verifying that there are no errors in the 2nd phase of the application which is in the called page. I cannot get commit() to work in the called page. Calling it in the previous page is not an option as this makes it impossible for the rollback to occur after commit() has been executed.
The dbase table are mysql InnoB
as always Im in a hurry, thanks for any help