Yes thats an interesting idea, and this compare-and-modify-if-unchanged bit would be implemented via SQL IF statement(s) perhaps?
Thanks Ollie "Hugh Bothwell" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > > "Oliver Cronk" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Thanks for that answer, you filled in some of the blanks for the table / > > logging solution, but I am now looking at row locking instead of a > seperate > > table (and then doing things similar to what you outlined). > > Just a thought - if you have the user form echo a copy of the original data > back (ie in addition to the modified data), you can compare it to the > existing data and warn the user if the data has been changed in the interim. > You must make the [compare-and-modify-if-unchanged] atomic, but that's okay, > because it's all in the same script anyway - it becomes reasonable to do it > as a transaction. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]