I'm trying to make an search script and it works fine if I write the username exactly as written in db with capital letters and lowercase letters. But I want to be able to search ignoring uppercase and lowercase... How do I do so?
$search = $_GET['q'];
$sql = mysql_query("SELECT * FROM ".$prefix."_users WHERE email = '$q' OR username = '$q'");
$row = mysql_fetch_assoc($sql);
Thanks in advance