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...
that is IT WILL BE ROLLED BACK !
Good fortune !
Gabriel PREDA
> -----Original Message-----
> Andre Matos @ February 07, 2005 6:45 PM
> 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"
> This sequence will be written in PHP4. My question is:
> Will the record "named B" be written in the database or it will be
rollback
> with the record "named A"?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
