Re: Maintaining data integrity with multiple users
Posted by google@tfwasmus.enschedenet.nl on 09/28/52 11:48
Never lock the data, it will indeed cause problems.
As discussed lately: there is no real way to prevent user B from seeing
the outdated data, but submitting it can be stopped by:
1. hidden inputs in the form containing the original data.
2. UPDATE tbl SET field1 = $_POST['field1'], field2=.......... WHERE
field1= $_POST['old_field1'] AND field2=.........