$search = "Joe.Bloggs@gmail.com"; $sql_search = mysql_query("SELECT email FROM users WHERE LOWER(email) = LOWER('$search')"); echo mysql_error();
You may be thinking why didn't I just use strtolower on $search and query the database normally. Well because you might not always know the value of $search as it might be an incoming form value. In this example, Joe Bloggs might know his email address as Joe.Bloggs but you have him in your database as joe.bloggs.
← RSS Structure Hover Animations →