How do I make an authentication not case sensitive?

[Infected-Waffle]

okay so I've got this login, but it requires me to put my username in exactly as it is in the database. This gets kind of tedious. How could I make it so that it will accept both upper and lower case?

Here's the code if it helps...

[code]if($mode == 'login') {
//login
$username = $_POST['username'];
$password = md5($_POST['password']);

$query = 'SELECT name, password FROM users WHERE name = "'.$username.'"';
$result = mysql_query($query);
$row = @mysql_fetch_array($result, MYSQL_ASSOC);

if($username == $row['name'] && $password == $row['password']) {
$_SESSION['logged_in'] = $row['name'];
header('location: index.php');
} else {
$content = 'Invalid Login credentials';
}
mysql_free_result($result);[/code]

[BillyBoB]

this would require some work but couldnt u just change all the letters to lower case b4 goin into db and then just change all letters to lower case when tring to match?