I believe you can use transactions with InnoDB tables on MySQL, if this is the case, a simple "BEGIN;" to begin your transaction, and a "COMMIT;" to save all the changes, plus a "ROLLBACK;" to undo your changes, should be sufficient.
On Mon, 2004-03-29 at 13:12, Matthew Oatham wrote: > Hi, > > Is there an elegant way to recover from DB errors in MySQL using PHP, i.e. > transactions and rolling back - basically I have an insert statement then an update > statement. if the insert succeeds the update is run but if the update fails I want > to undo the insert! > > Any suggestions, I guess I could get the last inserted row id and perform an sql > delete but is there a more elegant way? > > Cheers > > Matt -- Adam Voigt [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
