I'm confused abt running transactions through php script. In my MySql autocommit is set to 1, yet when I run a script
ex: mysql_query("START TRANSACTION");
$sql="INSERT INTO `address`(`Address_Id`, `Address_Line1`, `Address_line2`, `Zip`, `Created_By`, `Created_Date`, `Updated_By`, `Updated_Date`) VALUES ('2','this is test1','test2','210','SYSTEM','NOW()','SYSTEM','NOW()')"; mysql_query($sql);
When I don't give commit, inserted records in the table is zero. the record comes up only if I give commit command.
Also please tell me what happens if in a php script I start transaction and then dont give either roll back or commit statements</div