Hi, I have a PHP script that is running 4 queries. If the 4th fails, ideally I would like the other 3 queires to roll back and leave the database as if they were never run at all.
Can anyone advise on any technique that would do this easily, as opposed to manually writing and running queries to set the database back (which would be messy IMO). This project is being developed on MySQL 3.23.37. Any help is appreciated, thanks. Andy Hall.