I am using the innoDB engine and have build a basic ecommerce site. I start a transaction for each new visiter and when they add items to their cart the qty of the product in the relevent table (product table) is adjusted accordingly. The transaction is only commited when the order is placed.
Please can someone help?
P.s the only table that is of type innodb is the product table so a rollback will only affect the relevant bit.