This topic is locked

stop 2 users editing same data

2/25/2008 6:21:53 AM
PHPRunner General questions
G
garethp authorDevClub member

Hi
Not being a programmer I am hoping someone may be able to help.
I have a table `parts` with fields `partid` and `description`
If one user is editing a particular partid (changing the description) is there a way I can stop another editing the same partid at the same time?
Many thanks for all the great support

J
Jane 2/26/2008

Hi,
unfortunately there is no good way to implement record locking via PHP and Web browser.

I recommend you to use MySQL resources for that:

http://dev.mysql.com/doc/refman/5.0/en/innodb-locks-set.html

G
garethp authorDevClub member 2/28/2008

Thanks Jane for help.