On Thu, 8 Aug 2002 angelo.rigo@xxxxxxxxx wrote: > sorry for this off topic > > but someone ask me: if i do a invalid query in the middle of a transaction > i need to do a rollback . Basically, in PHP, just about any error will cause the current transaction to fail and rollback automatically and completely. You don't have to clean up the mess, as it's already cleaned up for you. Then you can just try running the transaction again and see if it goes through.