Any reason you can use a version of MySQL that contains transaction aware tables?
-----Original Message----- From: Andy Hall To: [EMAIL PROTECTED] Sent: 3/11/04 8:29 AM Subject: Best practise roll-backs? 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]