transcation processing with mySQL

[Anon]

hi guys,
plzz could anyone tell me how to do transcations in mySQL.

thanx in advance
Pravish

[Anon]

Can you explain the type of transaction and give some examples?

[Anon]

[Remove YOUR_CLOTHES to reply by email]

mysql_query("BEGIN", $dbh);
...
lots of sql statements here
...
mysql_query("ROLLBACK", $dbh);

OR

mysql_query("COMMIT", $dbh);

Otherwise, you can find my generic solution at the mysql function page in the PHP manual.

[[deleted]]

You could at least try to read the mysql manual...

[Anon]

With PostgreSQL, it's simply a matter of applying the BEGIN; command before executing the SQL statements.

After you apply some conditional statements (rules), you can then either "COMMIT;" or "ROLLBACK;" the transaction.

Roj
Founder
pgHoster.com
PostgreSQL web hosting