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
