transaction in MySQL

[Anna]

How to apply MySQL transaction in PHP ?

[Pedro Graca]

Re: transaction in MySQL

Anna wrote:[color=blue]
> How to apply MySQL transaction in PHP ?[/color]

You have to use InnoDB or BDB databases.

Check out

http://www.mysql.com/doc/en/ANSI_diff_Transactions.html

--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Phil Roberts]

Re: transaction in MySQL

With total disregard for any kind of safety measures annakk@go2.pl
(Anna) leapt forth and uttered:
[color=blue]
> How to apply MySQL transaction in PHP ?[/color]

mysql_query('BE GIN TRANSACTION_NAM E');

mysql_query('SE LECT * FROM whatever...')
mysql_query('UP DATE blah blah...')

if(check for errors) {
mysql_query('RO LLBACK');
} else {
mysql_query('CO MMIT');
}

Or something along those lines...

--
There is no signature.....