make sure user doesnt exist.......

adam_uk · 07-27-2003, 07:22 AM

hi im building a user system and its all working except the bit where the user already exists

anyone got any ideas how i should go about checking for duplicate users

web guru · 07-27-2003, 08:56 AM

Not sure if theres any special way of doing this, but I take it your checking for duplicate users every time someone logs into the system. If I am correct in assuming this you could simply add a boolean field called 'logged_in' to your database where you check your passwords. eg.

user already logged in = 1
user not already logged in = 0

Check this field every time a user tries to log in. If its set to 0 log the user in and set the field = 1. If the user is already logged in (field = 1) redirect the user to another warning page.

Not sure if thats any help just made it up of the top of my head there now.

adam_uk · 07-27-2003, 01:27 PM

thanks ive sorted it, not sure if i took the long way round but when i add a user it trys to select that user from the database if it does then then errors if it doesnt select it it adds it

07-27-2003, 07:22 AM	#1 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	make sure user doesnt exist....... hi im building a user system and its all working except the bit where the user already exists anyone got any ideas how i should go about checking for duplicate users

07-27-2003, 08:56 AM	#2 (permalink)
web guru NamePros Member Join Date: Jul 2003 Posts: 120 185.00 NP$ (Donate)	Not sure if theres any special way of doing this, but I take it your checking for duplicate users every time someone logs into the system. If I am correct in assuming this you could simply add a boolean field called 'logged_in' to your database where you check your passwords. eg. user already logged in = 1 user not already logged in = 0 Check this field every time a user tries to log in. If its set to 0 log the user in and set the field = 1. If the user is already logged in (field = 1) redirect the user to another warning page. Not sure if thats any help just made it up of the top of my head there now. __________________ Paulicon Web design - Your one stop shop

07-27-2003, 01:27 PM	#3 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	thanks ive sorted it, not sure if i took the long way round but when i add a user it trys to select that user from the database if it does then then errors if it doesnt select it it adds it

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)