RE: [PHP] Lost Update Problem

This one has never affected me, but I guess you could pass both the old and new values to the script and before applying the update, make sure that the old values match the ones in the database. If they don't; warn the user and don't commit the change to the database. Ollie > -----Original Message----- > From: rodrigo [mailto:rodrigo@shreve.net] > Sent: 19 November 2000 20:53 > To: php php > Subject: [PHP] Lost Update Problem > > > Hello. I would like to know what are some of the methods the > members of > this list use to cope with the lost update problem. > > For those of you who don't know, the Lost Update Problem (as far as I > know) is this: When two people pull a record to perform and UPDATE > query. Both pull the record at the same time, but the save it to the > database at different times. Neither of the users pulling the record > knows what the other is doing to the data. The last one to submit the > change is the one that will be recorded. Therefore, the update of the > person who submits first is lost. > > Thank you. > > -- > ************************************ > Ivan R. Quintero E.* (507)228-3477 > Aptdo 1263 * (507)228-9105 > Balboa, Ancon * > Republic of Panama * > ************************************ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >