multiple queries, one transaction
| From: | mayo | Date: | Fri, 20 May 2005 21:02:11 +0000 |
| Subject: | multiple queries, one transaction | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-215683@lists.php.net to get a copy of this message | ||
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 transaction
I'm just not certain how it's used.
Thx, mayo