I was wondering about case sensitivity
when i do this
$member = mysql_query("select password from tblMembers where UserName = '".$_POST['UserName']."'");
I am trying to retrive the password from a MySQL database for a unique user with a unique username, however....the query above is case insensitive ...in other words it retrieves all the passwords for any username like the posted username value
lets say the client types in John on the posting form .....it works but its not case sensitiive....if someone types in John or jOhn or JOHN or johN, or any variation of John with variable cases....it will retrieve all the passwords...
how do i make that query abouve case senstivie so only the correct user "John" , can log on ?
