RE: [PHP-DB] Using MySQL Inno DB transaction

I would think that it all has to occur in one script since the db connection is closed with an implicit commit when the page ends bastien

From: Arie Nugraha <dicarve@gmail.com> Reply-To: Arie Nugraha <dicarve@gmail.com> To: php-db@lists.php.net Subject: [PHP-DB] Using MySQL Inno DB transaction Date: Tue, 12 Jul 2005 16:37:56 +0700 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