i put 'begin; update......; commit;' into a string. then i put that string in mysql_exec(..) but it didnt update my table in MySQL. would like to know if 'begin and commit' can work with php 4.0.6 (also i tried to put my SQL statement in phpMyadmin, it worked smoothly). thanks
Try sending each line as a separate query... mysql_query('begin'); mysql_query('update...'); mysql_query('commit');
This oughta work and it also allows you to do other PHP stuff in between.
