Database transactions are important for data reliability and consistency. Used properly, they can prevent many types of errors. Used improperly, they can cause many other kinds of errors. Kimberlee Jensen demonstrates using transactions with PHP well.
Link Details for: Pitfalls of Transactions with PHP (ONLamp)
