John W. Holmes wrote:

Tim Best wrote:

Anyone know how you set a lock in a MySQL table using PHP?

I tried:

$select = ³LOCK TABLES t1 WRITE;²;
$select .= ³select * from t1;²;
$select .= ³UNLOCK tables;¹;

When I run mysql_db_query(³db²,$select,$conn); it always returns nothing.
Any insights would be appreciated!

Run one query at a time.

and don't use mysql_db_query(), use mysql_select_db() and mysql_query()...

---John Holmes...

Amazon Wishlist:

PHP|Architect: A magazine for PHP Professionals –

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to