Login with username, but login with lowercase username

luska

New Member
I have recently had alot of suggestions on my website, and one of them was to allow them to login with their username in lowercase.If JoHNdoE had their username like that in the database, I'm sure it would get quite annoying if they tried to login and having to remember where they put those capitals.So I wanted to make it so they John Doe could login with this username johndoe instead. MUCH MUCH easier to remember.my query is currently\[code\]$get_user_info = mysql_query("SELECT * FROM users WHERE username = '$entered_username' AND md5_username = '$md5_entered_username' AND password = '$entered_password' LIMIT 1");\[/code\]And then it will continue with \[code\]if (mysql_num_rows($get_user_info)==1) {//then log them in} else {//kick 'em out!}\[/code\]How would I go about this?
 
Top