example: making a payment transfer from user A to user B. Account of user A: -10 USD Account of user B: +10 USD
if there is an transaction, and something goes wrong, everything gets undone. So with transactions it will not happen that account of user A gets decreased by 10, while account of user B does not get increased by 10.
I know the java people make use of transactions and rollbacks all over the place. But I've never heard of PHP-guys doing that.