Re: Table locking
| From: | John W. Holmes | Date: | Thu, 08 Jul 2004 23:04:01 +0000 |
| Subject: | Re: Table locking | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35160@lists.php.net to get a copy of this message | ||
Rosen wrote:
I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to "understand", thath another user is filling table, and to wait before begin to fill data?Most databases have a LOCK command that you can issue. The other scripts that end up running at the same time will wait until the lock is released. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com