How can i syncronize

[siri_suresh]

I have a syncronization problem

"I have two administrators they can create user and they can change the user proprietaries. If one administrator is open the some particular user for the modification, that user details should not allow for modification until the administrator save or cancel the user details, by the other administrator but he could able to see that user details. I have a solution that there should be a key in database for user so that only one administrator can allow to modify the user details. But the problem is when the administrator is not properly shut down his browser or some power failure problem or WEB server is it self down (WEB server and Database servers are maintaining on different machines), the key (in database) holds by administrator will not be released".

How can i solve the above sincronization problem.I am using PHP on Apache and oracle as database server.

Please help me in this regard.

Thanking you
Suresh

[[deleted]]

Add a 'locked-date' column and a 'locked-by' to your table.

When an admin edits a record, change that record's 'locked-date' value to the date and time that the lock was set.
If another admin want's to edit the same record, check if the locked-date was set.
If the record is locked-by a different admin, but the locked-date is more than X minutes ago, then the lock has expired, and you can lock the record again but now for this admin.