Thanks guys, this is great info. One last thought, Suppose I have several DB transactions that I want to treat as 1 logical transaction that I need to complete guarenteed. For instance, an INSERT to one table, and a DELETE to another, and an UPDATE to a third. All need to complete once a user selects submit. What's the best approach to this scenario? Thanks in advance for the help, David -----Original Message----- From: Matt Matijevich [mailto:matijevich@xxxxxxxxxxxxxxxxxxxxxxxx] Sent: Wednesday, February 04, 2004 11:17 AM To: php-db@xxxxxxxxxxxx; php-db@xxxxxxxxxxxxx Subject: Re: apache/php/mysql - guarenteed DB transaction <snip> Actually whether the script runs through to completion depends on the 'ignore_user_abort' setting. </snip> wow, guess you learn something everyday. wish I would have known about that when I wrote a php script with some terrible (lots of joins, just poorly designed) queries that took down my webserver :( -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
