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
$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