The PHPBuilder guys have a new article talking about Best Practices: Database Transactions
The general idea behind a transaction is that several steps can be performed in series, with the capability to undo all of the steps at once if needed.
This article not only provides a good overview of transactions, but also is a good compliment to the other "Best Practices" articles.