[PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

Hi, How can I avoid two or more users to update the same record at the same time ? Ideally, I would like to lock the record when a user open it for modification. So if another user try to open the same record he'll be warned or get record values as read only. Is this possible and how to do it

RE: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

Thanks a lot for all these answers. The discussion between Doug and Thomas was really usefull. I think I'm gonna give a try to the timestamp/checksum method, which seems to best fit my needs. Best Regards, Nicolas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: