[eluser]bretticus[/eluser]
[quote author="asciiCode" date="1283465819"]Assuming I get InnoDB setup ... just to be clear it is ok to have php logic between the trans_start and trans_compete calls? [/quote]
Absolutely. when you run trans_start, later, trans_commit will automatically roll back if any of your queries fail. What's in between shouldn't affect it because transactions only concern themselves with changed data for unsuccessful transactions.