Hello MySQL isn't a transactional DB it doesn't know rollback and commit. You can solve the problem probably by locking the tables (LOCK / UNLOCK) Regards Koen On 07/11/05, Bastien Koert <bastien_k@xxxxxxxxxxx> wrote: > I don't think you can. Once the script finishes the connections are closed > and the transactions completed. What are you trying to do where you need to > have the transaction across multiple pages? Perhaps, if you are gathering > the data across the pages, you could use a session to store the data until > you have all the elements, then start the transaction, so your inserts and > commit... > > Bastien > > > >From: martin lutsch <martin.lutsch@xxxxxxxxxxxxxxxxxxxxxxxx> > >To: php-db@xxxxxxxxxxxxx > >Subject: transactions > >Date: Mon, 07 Nov 2005 11:18:53 +0100 > > > >hi, > > > >i have a problem with mysql transactions and php: > >i want to do a transaction through more than one php scripts. i think, > >if one script ends and links to another, the database connection ends > >and the transaction rolles back. how can i continue one transaction > >through more than one script? > >any ideas? please help, > > > >cheers, martin > > > >-- > >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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
