$auto="START TRANSACTION;";

      $com="COMMIT;";

      $sql_car="UPDATE `usercars` SET `state` = 1 WHERE `usercars`.`id` =1;" ;


      $sql_car1="UPDATE `advertisments` SET `tel` = 505 WHERE `advertisments`.`id` =1;" ;


//     echo mysql_query($auto.$sql_car.$sql_car1.$com);

    try{
      echo "start\n";


        $db_host="localhost";
        $db_user="root";
        $db_pass="speed@2011";
        $db_name="optimze";


         $db = mysql_connect("$db_host", "$db_user", "$db_pass")
         or die("Could not connect: " . mysql_error());
         mysql_select_db("$db_name") or die("Could not select database");




          echo $auto.$sql_car1.$com;

           echo mysql_query($auto.$sql_car1.$com);

           echo '<br/>'.mysql_affected_rows();

           echo "\ncommit";

    } catch (Exception $err)
    {


        echo "rollll";

        $ro="rollback;";


        mysql_query($ro);
        echo $err->getMessage();


}