Hi!
I have made a website where different users can access (read/write) the same information.
If two users loads the same piece of data to edit, there might be problems.
When one user is finished editing the data, she presses "Submit", and the data are stored/updated in the MySQL database.
But since the other user is still editing the old data (which she loaded before the first user updated the database), she will press "Submit" when finished, and the editing/updates made by the "fastest editing" user is lost.
Are there any methods/functions to prevent this from happening ?
Of course, the more users - the more times this will happen...
I guess one could insist that the user should click "refresh" after pressing "Submit" to chech wether the updates are made correct - but that is not a optimum solution.
Any help would be appreciated
Torbj鴕n
I have made a website where different users can access (read/write) the same information.
If two users loads the same piece of data to edit, there might be problems.
When one user is finished editing the data, she presses "Submit", and the data are stored/updated in the MySQL database.
But since the other user is still editing the old data (which she loaded before the first user updated the database), she will press "Submit" when finished, and the editing/updates made by the "fastest editing" user is lost.
Are there any methods/functions to prevent this from happening ?
Of course, the more users - the more times this will happen...
I guess one could insist that the user should click "refresh" after pressing "Submit" to chech wether the updates are made correct - but that is not a optimum solution.
Any help would be appreciated
Torbj鴕n