Re: [PHP] multiple queries, one transaction

On Fri, May 20, 2005 2:02 pm, mayo said: > I have a site where I need to do multiple queries in sequence. In sequence, or as one single atomic un-interruptable action? Cuz, like, just doing them in sequence is real straight forward: $query = "select ... "; $meaningful_variable_names_are_good = m

[PHP] multiple queries, one transaction

I have a site where I need to do multiple queries in sequence. I see there is a way to do consider all querys and to fail the entire procedure if one query fails. It's a BEGIN and COMMIT statement. mysql_query("BEGIN"); // starts the transaction mysql_query("COMMIT"); // ends the transac