Posted by Colin McKinnon on 06/27/05 11:18

willl69 wrote:

> Hi Guys
>
> I was just wondering if there is any possible way to lock a row in a MySQL
> database when a person is editing it so that another person cannot log on
> and edit it at the same time? Any help would be greatly appreciated.
>

Not a PHP question.

Since the mysql session ends when the script has generated it's output, then
you can't lock it using the builtin mechanisms - you'd need to implement
your own locking protocol.

C.

[Back to original message]