IIRC, someone added automatic rollback to MySQL from PHP 4.3.0 just like PostgreSQL. BTW, PostgreSQL module rollbacks uncommitted transaction automatically from PHP3. -- Yasuo Ohgaki John W. Holmes wrote: >>I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use >>InnoDB tables for transactions and everything works fine with Rollback > > and > >>Commit. But when the user presses cancel in the browser or the script >>stops >>due to an error in the script all open transactions are committed > > instead > >>of rolled back. Is there some way to change this behavior ? > > > Look at the Connection Handling functions in the manual. > > http://www.php.net/manual/en/features.connection-handling.php > > You can detect when the user has aborted the script (pressed cancel) and > react accordingly. > > ---John Holmes... > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
