I know I saw this somewhere before but cannot find the answer

In a php/mysql script  how do a do a transaction

is it like this or is their a better way to do it? 

innodb table method

$query="set autocommitt=0;"
mysql_query($query);

$query="select blah from blah;";
mysql_query($query);

$query="update blah where blah;";
mysql_query($query);

$query="committ;";
mysql_query($query);


Thanks

Randy



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to