weird comparison problem

[Pag]

This msg keeps bouncing off the list.
First off, thanks for the hint on displaying several pages of news. :-)

Am having a bit of a weird problem with a SELECT on my MYSQL database:

If i use this:

SELECT * FROM tablehere WHERE userid = '$uid' AND password = '$pwd'

with $uid and $pwd being vars from a login form, and "Miguel" being userid on the table, i can login if i type "miguel" on the form. No matter if i type uppercase or lowercase, it always logs in, how can that be? "Miguel" is != to "miguel". (but if i misspel it, it fails, as it should :-)

How can i make a correct check with upper case distinction?
Thanks

Pag


---------------------------------------------------------------------
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