[PHP-DB] Multi-User Update Problem

2004-11-29 Thread SCALES, Andrew
Hello, Does anyone know a good way of locking out access to a record on a MySQL database when someone has the update page open? The problem is that we have a local intranet site which is accessed by members of different departments. Now at the moment when someone loads the page all of the data is

RE: [PHP-DB] Multi-User Update Problem

2004-11-30 Thread SCALES, Andrew
I apologise if my explanation caused confusion. What I meant to say was that the update page will pull down the relative record as chosen by a search page prior to the update page and then populate the form with that data. Then when someone submits the form all of the fields will be updated in that

RE: [PHP-DB] Multi-User Update Problem

2004-11-30 Thread SCALES, Andrew
ct) and > then compare any changes made upon submission. I have seen > this but I don't > really like it, since the ultimate choice is left to the user > as to what > data is correct. > > > > Bastien > > >From: "SCALES, Andrew" <[EMAIL

[PHP-DB] RE: Multi-User Update Problem

2004-12-06 Thread SCALES, Andrew
Thank you everyone who replied to my problem. I have decided now to go with Anna's solution and so far it's working great! So thank you very much for your help Anna. Thanks again, Andy. -Original Message- From: anna w [mailto:[EMAIL PROTECTED] Sent: Wednesday, 01 December 2004 11:17 To: [