ballouta Posted September 13, 2008 Share Posted September 13, 2008 Hello a user has chosen his username while registration as: MaLeK This username is stored as is correctly in the DB table. When i query the table and search for username: 'malek' (small letters), the query returns a result and if I echo it it is: MaLeK ! I want this query when searching for usernames to be case sensitive. my code is: <?php $query = "SELECT * FROM `members` WHERE `user` = 'malek' "; ?> Please help Link to comment https://forums.phpfreaks.com/topic/124046-solved-username-problem/ Share on other sites More sharing options...
DamienRoche Posted September 13, 2008 Share Posted September 13, 2008 here's a helpful a <a href="http://mysqldatabaseadministration.blogspot.com/2006/09/case-sensitive-mysql.html">link</a> Link to comment https://forums.phpfreaks.com/topic/124046-solved-username-problem/#findComment-640388 Share on other sites More sharing options...
ballouta Posted September 13, 2008 Author Share Posted September 13, 2008 thank you i will read it now Link to comment https://forums.phpfreaks.com/topic/124046-solved-username-problem/#findComment-640392 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.