Re: Table locking

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is thath mean, thath, when one user is addind records to table, and lock
it - when another user is trying to get the max field value for some field,
the script will waiting the first user to unlock table and then to see the
max value of some field in a table ?


"John W. Holmes" <holmes072000@xxxxxxxxxxx> wrote in message
news:40EDD2E1.6030508@xxxxxxxxxxxxxx
> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux