How to lock mysql tables with PHP4?

[Anon]

How do I lock mysql tables with PHP4?
Just call mysql_query( "LOCK TABLES..." ) ?

[Anon]

Review the documentation at mysql.com.

http://www.mysql.com/documentation/mysql/commented/manual.php?section=LOCK_TABLES

[Anon]

here some sampe sql statements and the sequence for it.

mysql> LOCK TABLES trans READ, customer WRITE;
mysql> select sum(value) from trans where customer_id= some_id;
mysql> update customer set total_value=sum_from_previous_statement
where customer_id=some_id;
mysql> UNLOCK TABLES;

Now all you have to do is submit each as query statements using the mysql_query("..") and it should work.

Daron
He is coming Again

[Anon]

BTW

These statements were executed for the msyql monitor. Only use the sql statement. not the stuff before.

Daron