Hey. I am using mysql, php, and javascript (jquery).
I have a nice form setup where the username field validates AJAX-style against my database... this technique allows for the user to see if his username is already in use, while he is typing.
Problem is, I am only validating against the the exact (case-sensitive) value returned from the database. I want to make sure there can't be a user 'pete' and 'Pete'.
Any suggestions would be appreciated. ATTN: Moderators, this post may belong in either PHP or MySQL... I don't know if there is a fancy select statement I could use, or php method to compare against.
Thanks,
Pete