check for case sensitive username/password

[Zaggs]

Hi Guys,

How can I check for case sensitive usernames and passwords using PHP & MySQL?

I have tried the following without success:

select id from table where username='".$_POST['username']."' and password='".md5($_POST['password'])."' collate latin1_bin 

Thanks in advance...

[hannson]

This belongs in the database forum... but anyway, a quick google search popped this up: http://gilfster.blogspot.com/2005/08...-in-mysql.html

[Mittineague]

BTW. You really don't want to use POST directly in your queries like that.