No the transaction will not be rolled back...
BUT (always the BUT thing)...
If you're not carefull to open a NEW link in MySQL setting the fourth
parameter to "mysql_connect" to TRUE... PHP will not open a new link but
return the already created one... thus entering in the same transaction...
t
Andre Matos wrote:
Hi List,
Let's suppose that I have this sequence of events:
- create a connection "1"
-- start a transaction
--- create a new connection "2"
insert a new record "named B"
--- close the connection "2"
--- insert a new record "named A"
-- rollback
- close the connection "1"
Th
Assuming that the record "named B" is insterted using connection "2", and the
transaction is started and rolled back using connection "1", that record should
not be rolled back.
You can experiment with things like that easily from multiple terminal windows
or a graphical client.
-Original
Thanks alot Cal.
-Steve.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 9:38 AM
To: Steve Bradwell; [EMAIL PROTECTED]
Subject: RE: Innodb and transactions
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('I
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('Insert something'))){
mysql_query('COMMIT');
} else {
mysql_query('ROLLBACK');
}
I'm working from memory here. I use the ADODB wrapper and it works a little
different. (Look into it, it's a great piece of code)
HTH,
=C=
-Orig
