convert variables to lowercase before comparing

[smartic]

i need to know how can i compare two strings one from database uppercase ex:'SmaRtic' and the other lower case ex:'smartic'.

that is my code when the user post his data :

[PHP]$QUERY = mysql_query("SELECT User FROM users WHERE User='$User'");
$R = mysql_fetch_assoc($QUERY);
if(strtolower($R['User']) == $User){
$errors['username']='Someone has already chosen that username. Please choose another one!.';
}[/PHP]

[Markus]

i need to know how can i compare two strings one from database uppercase ex:'SmaRtic' and the other lower case ex:'smartic'.

that is my code when the user post his data :

[PHP]$QUERY = mysql_query("SELECT User FROM users WHERE User='$User'");
$R = mysql_fetch_assoc($QUERY);
if(strtolower($R['User']) == $User){
$errors['username']='Someone has already chosen that username. Please choose another one!.';
}[/PHP]

Does that not work?
It looks like it should..

[TheServant]

[PHP]$QUERY = mysql_query("SELECT User FROM users WHERE User='$User'");
$R = mysql_fetch_assoc($QUERY);
if(strtolower($R['User']) == $User){
$errors['username']='Someone has already chosen that username. Please choose another one!.';
}[/PHP]

How about instead trying:

[PHP]$QUERY = mysql_query("SELECT User FROM users WHERE User='$User'");
$R = mysql_fetch_assoc($QUERY);
if(strtolower($R['User']) == $User){
echo('Someone has already chosen that username. Please choose another one!');
}[/PHP]

[hsriat]

[php]if(strtolower($R['User']) == strtolower($User))[/php]

[smartic]

it work when i use this code why ?
[PHP]
SELECT `user` FROM `users` WHERE `user` = CONVERT( cp1256 'smartic' USING utf8 ) [/PHP]

[ronverdonk]

it work when i use this code why ?
[PHP]
SELECT `user` FROM `users` WHERE `user` = CONVERT( cp1256 'smartic' USING utf8 ) [/PHP]

That is not lowercase conversion or comparison.

Ronald