Lately i'm building a library automation application with php 5 and MySQL 4..1. For the transaction module, i'm using Inno DB engine to store the transaction data, cos i want to use MySQL transaction method which can be commit or rollback. But when i tried to rollback the transaction in the other script, the data still exist in the database. script1.php : <?php $mysqli = new mysqli(...); $mysqli->autocommit(false); // do the transaction // and process it in script2.php ?> script2.php <?php $mysqli->rollback(); ?> What's wrong?? does anybody could help me?? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php