[RESOLVED] Mysql transaction

[adi]

Hello.

I have the following queries:
"INSERT INTO tblA (Field1, Field2) values ('a', 'b');

"INSERT INTO tblB (Field1, Field2) values ('a', 'b');

"INSERT INTO tblC (Field1, Field2) values ('a', 'b');

I want to use Mysql Transactions to be sure that all queries have been executed o abort them all if one ended with error.

Thank you.

[laserlight]

You might want to state which database extension you are using, along with the version of MySQL and storage engine for the tables.

[adi]

Mysql version: 5.1.30
ENGINE=InnoDB

Thanks.

[laserlight]

In that case I assume that you are using the PDO extension, so take a look at PDO::beginTransaction and PDO::commit.

[adi]

Ok, i'll give it a try.

Thank you.