'begin tran' in php does not work

[munnymun]

I use begin and commit in php with mysql. it does not work. my code is like
$sql = 'begin;
update.......
commit;';
$test = mysql_query($sql);

i also put my sql code in phpmyadmin and it worked smoothly. please help why i cannot use 'begin and commit' in php. thanks

[[deleted]]

You cano only execute one query at a time through PHP:

mysql_query('BEGIN');
mysql_query('UPDATE .....');
mysql_query('UPDATE .....');
mysql_query('INSERT .....');
mysql_query('DELETE .....');
mysql_query('COMMIT');

[munnymun]

Thanks a lot, Vincent