Andrew,
> > If i use code at PHP IN ONE PAGE - that uses like :
> > SET COMMIT
[snip]
> > All Actions - work OK - COMMIT & ROLLBACK
> > But if i try use every Insert at defferent page (php)
[snip]
> > p1.php - has
> > SET COMMIT;
> > INSERT ....1
> > <FORM ACTION=p2 ?>
> > {go to p2.php}
> > INSERT ....1
> > ROLLBACK;
> > - THIS IS NOT WORKED !
> > WHY ?
Because of the isolation level of transactions. Thread (client) 1
(p1.php) does not know about the queries / transactions of thread
(client) 2 (p2.php).
I don't know if there is a workaround for this, and even if there is a
need for a workaround. From all I know of your application (which is
little), I believe there's a problem with your application design.
Splitting up a transaction over two different scripts is IMHO no good
idea.
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschaftsfuhrer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
----- Original Message -----
From: "Andrew B. Sokov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 29, 2002 7:40 PM
Subject: MySQL InnoDB
> Hello mysql,
>
> > tell me please where i need write my question about InnoDB in MySQL
?
> > I was instaled on Linux Debian
> > MySQL 3.23.53-log
> > with InnoDN Tables.
> >
> > If i use code at PHP IN ONE PAGE - that uses like :
> >
> > SET COMMIT
> > ....
> > INSERT ...1
> > INSERT ...2
> > ...
> > COMMIT / ROLLBACK
> >
> > All Actions - work OK - COMMIT & ROLLBACK
> >
> > But if i try use every Insert at defferent page (php)
> >
> > Like
> > Page.php - has <FORM ACTION=p1.php> ....
> >
> > p1.php - has
> > SET COMMIT;
> > INSERT ....1
> >
> > <FORM ACTION=p2 ?>
> >
> > {go to p2.php}
> >
> > INSERT ....1
> > ROLLBACK;
> >
> > - THIS IS NOT WORKED !
> > WHY ?
> > Who can help me - and answer at my Question ?
> >
> > --
> > Andrew B. Sokov
>
> ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
••
> > Web-Media L.t.d. (812) 312-5309 27 äåêàáðÿ 2002 ã. 18:54
> >
> > URL: http://www.Web-Media.ru
> > e-mail: [EMAIL PROTECTED]
> > ICQ UIN# 83040728
> > phone: +7 (812) 312-5309
> > fax: +7 (812) 312-5309
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
