Does anyone know a good way of locking out access to a record on a MySQL
database when someone has the update page open?
The problem is that we have a local intranet site which is accessed by
members of different departments. Now at the moment when someone loads the
page all of the data is pulled into the form, and then when they submit, all
of that data is passed back to the database, including anything they haven't
What we are trying to avoid is situations where for example someone leaves
the form open on their computer and goes away for lunch. In the meantime
someone else at a different station makes changes to the form. Then when the
first person comes back from lunch, they submit the form, thereby writing
over all of the second person's changes with the old data.
Does anyone know of a good way to solve or work around this problem? We have
thought about setting a flag on the database whenever someone pulls down the
data, however if their browser crashes or they shutdown with the window open
then this is going to leave the data locked.
Thanks very much,
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php