Hi What about a table with logged in user ids and a timestamp (I use a sessions table).
Update the timestamp when they access the system. Check when a user tries to login. If that user id, but a different person, has accessed the system within the last xx minutes or seconds then consider them logged in and deny the second user. You need to deal with browser crashes and such, but it works otherwise. email me off list if you want the table structure and php code HTH Peter > -----Original Message----- > From: Walter D. Funk [mailto:[EMAIL PROTECTED]] > Sent: 06 December 2001 21:31 > To: [EMAIL PROTECTED] > Subject: Fw: locking specific rows > > > Hi, > > I need to implement an access/logging system in mysql+php, > which once a user logs in, does not let another > individuals log in using the same user-password. I donīt care if users > share a user-password, the only thing I want to avoid is that this users > sharing the same user-pw combination, donīt acces at the same time. > > is there a way to lock the row when the user first logs-in > I know that it exist table locking, but I only need to lock a specific > row when the user is logged in. > > sorry if Iīm not very clear, hope everybody can figure out what Iīm trying > to do > > > thanx > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
