Peter Westergaard wrote:
I'm developing a site where I anticipate the need to make several updates to several forms, and I'll want to "commit" them all at once (i.e. if there's a failure with any of the transactions, I'd like to be able to back out to before I started).
Is there a decent way to do this with PHP and Mysql?
Use InnoDB tables which have transaction support.
Or use a database abstraction layer that simulates transactions such as ADOdb: http://phplens.com/adodb/tutorial.smart.transactions.html
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php