Hi,
I have a log in form but for some reason some usernames work and some dont. I’ve never encountered something like this before so I thought I would throw it out there to see if any fellow kirupians can help.
Basically I have this simplified query for finding a user in a mysql db:
This works:
[FONT=Helvetica]SELECT * FROM Access_list WHERE username=“Colourjam” AND password=“5f4dcc3b5aa765d61d8327deb882cf99” AND active=“Yes” LIMIT 1
If I use this it doesnt work:
SELECT * FROM Access_list WHERE username=“lesleyannpotter” AND password=“5f4dcc3b5aa765d61d8327deb882cf99” AND active=“Yes” LIMIT 1[/FONT]
[FONT=Helvetica][/FONT]
[FONT=Helvetica]Both records are present in the database but for some reason the “lesleyannpotter” account isn’t found in phpMyAdmin when I run the query even though its there. The Colourjam account is found no problem. Both entries have the same password stored in the db as MD5. The hash = “password”.[/FONT]
[FONT=Helvetica][/FONT]
[FONT=Helvetica]Help! :}[/FONT]
[FONT=Helvetica][/FONT]
[FONT=Helvetica]Thanks[/FONT]
