transactions
| From: | Matthew Oatham | Date: | Mon, 29 Mar 2004 18:12:13 +0000 |
| Subject: | transactions | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-181684@lists.php.net to get a copy of this message | ||
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