Posted by rich on 05/23/06 03:08

Someone gave me even a better idea. Use sessions in a table. Add to
each user session a field for the Key field of each table in your
database that is important. Example use the key field for a customer
record. When you query the record for a change, write to that customer
field in your seesion table the index of the record you are on.
Whenever anyone opens that record, the ffirst thingyou do is query for
the record number you are going to change and if it is found you cannot
select the record because someone else has it open. Set your session
max life time low enough so that a user can't sit on a record too long.
This saves a person alot of work entering data only to be told someone
else was using the record. I think this is a nice way of doing it.

• Next in forum: Re: How do I handle people going into the same record at the same in web app.
• Prev in forum: Re: List of PHP functions and classes
• Thread view: Re: How do I handle people going into the same record at the same in web app.

[Reply to this message]