Hi,
I am trying to use database transactions in PHP. I know there is database transaction

support in MySQL but then I was wondering if there is any database transaction support in

PHP (the same way we have in ASP).

Any help.

Ranjan

im gonna raise my hand and ask what transaction support is

*raises hand*

Why would you need it in php? You can just call mysql_query("START TRANSACTION"); ?

leavethisplace - a transaction is a bunch of queries that all have to happen, or else none should happen. (The operations should be atomic). Think of a bank transferring money between accounts. If it subtracts from one account, but the system crashes or it meets an error condition before it adds to the other, then money disappears. Put them in a transaction and the system can rollback if anything fails.

Transactions only work on InnoDB tables within mySql, not the standard myIsam tables. You use transactions with simple SQL statements:
mysql_query("BEGIN");
mysql_query("COMMIT");
mysql_query("ROLLBACK");

Originally Posted by leavethisplace

im gonna raise my hand and ask what transaction support is

*raises hand*

When usging transactions and something is done to a database (ie insert, update, or delete), the database server will not make any changes permanent. Every update, insert, and delete statement is logged. This way, you can issue multiple update statements, and if one fails, you can "rollback", or undo all the other updates that happened. If all updates are done successfull, then you can "commit", or make permanant all the updates.

I hope I explained it clearly. If not, do a google search for 'database transactions', there are many tutorials about it.

Arg, your too quick for me 0beron

Your syntax is probably more correct!