Re: Table locks
| From: | John W. Holmes | Date: | Wed, 06 Aug 2003 01:48:18 +0000 |
| Subject: | Re: Table locks | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29708@lists.php.net to get a copy of this message | ||
John W. Holmes wrote:
Tim Best wrote:and don't use mysql_db_query(), use mysql_select_db() and mysql_query()... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP Professionals – www.phparch.comAnyone 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.