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? 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) 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 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. 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>. 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. Link to comment https://forums.phpfreaks.com/topic/66951-solved-database-queries/#findComment-335780 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.