Hi,
I am explicitly opening innodb transactions and commit and rollback them using mysql library provided in php. Sometimes innodb transaction fail to update one table but transaction commits. I have single dedicated mysql server, I asked this question on other forums but couldn't found solution.

Here is the pseudo code

START TRANSACTION
$result1 = mysql_query('UPDATE TABLE1 SET ..... WHERE X1=10');
$result2 = mysql_query('UPDATE TABLE2 SET ..... WHERE X1=10);
$result3 = mysql_query('UPDATE TABLE3 SET ..... WHERE X1=10);

if $result1 && $result2 && $result3
mysql_query('COMMIT);
else
mysql_query('ROLLBACK');

Anyone can help me on this?