Transaction (Begin...end) 1

[tcardoso]

Hi,

I'm trying to do:

$result = mysql_query("DELETE FROM `table` WHERE `field`='value'");
if (mysql_affected_rows()>0) {
   //Run rest of code			
}

My question is:
If after the DELETE runs on DB and before mysql_affected_rows() is called another DELETE or UPDATE, etc occur? Then mysql_affected_rows() its going to return the rows affected by this delete or by the last query to DB.

I found out that I can use Begin...end (

http://dev.mysql.com/doc/refman/5.0/en/begin-end.html)

But I never did it, can anyone give me an example (if this is necessary to use).

Thanks

 

[DonQuichote]

No. You have a connection to the database, and a connection behaves like a sort of session. No matter how many statements occur between your DELETE command and you querying the affected rows, you will get the affected rows belonging to your actions only.
This is also valid for LAST_INSERT_ID() and its counterparts in the various language APIs.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)