Ken2k7 Posted August 27, 2007 Share Posted August 27, 2007 mysql_query("SELECT * FROM member WHERE name='$name'") or die(mysql_error()); Is a database search case-sensitive in the "WHERE name='$name'" part? Quote Link to comment https://forums.phpfreaks.com/topic/66951-solved-database-queries/ Share on other sites More sharing options...
hostfreak Posted August 27, 2007 Share Posted August 27, 2007 You were already told that by default it isn't; http://www.phpfreaks.com/forums/index.php/topic,156767.0.html (Reply #7) Quote Link to comment https://forums.phpfreaks.com/topic/66951-solved-database-queries/#findComment-335765 Share on other sites More sharing options...
lemmin Posted August 27, 2007 Share Posted August 27, 2007 Go here for more info: http://dev.mysql.com/doc/refman/5.1/en/case-sensitivity.html Quote Link to comment https://forums.phpfreaks.com/topic/66951-solved-database-queries/#findComment-335768 Share on other sites More sharing options...
Ken2k7 Posted August 27, 2007 Author Share Posted August 27, 2007 Oh sorry hostfreak. I didn't check my previous topic. But thanks I was just seeing if it is case-sensitive or not and if it is, I was going to ask how to make it search case-sensitive wise. Quote Link to comment https://forums.phpfreaks.com/topic/66951-solved-database-queries/#findComment-335772 Share on other sites More sharing options...
hostfreak Posted August 27, 2007 Share Posted August 27, 2007 Not a problem, I just tend to see so many people open new threads when it isn't needed. As far as making it case sensitive, look into <a href="http://dev.mysql.com/doc/refman/4.1/en/charset-collate.html">COLLATE</a>. Quote Link to comment https://forums.phpfreaks.com/topic/66951-solved-database-queries/#findComment-335776 Share on other sites More sharing options...
Ken2k7 Posted August 27, 2007 Author Share Posted August 27, 2007 Thanks hostfreak. Quote Link to comment https://forums.phpfreaks.com/topic/66951-solved-database-queries/#findComment-335780 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.