LogIn Not Working

[pudge1]

For some reason my LogIn script doesn't work. It connects to the database and everything alright but it doesn't work at all. I've checked the database multiple time and the information I am inputting IS in there.

 

  function Login($username,$password)
    {
    $user = '***';
    $pass = '***';
    $dbname = '***';

    $connection = mysql_connect('localhost',$user,$pass);
    mysql_select_db($dbname, $connection);

    $sql = "SELECT Password FROM Users WHERE Username='$username'";
    $query = mysql_query($sql , $connection);

    $arr = mysql_fetch_array($query);

    $a_password = $arr["Password"];

     if($password == $a_password)
      {
       setcookie('LOGGED_IN','True_',time()+172800);
       setcookie('USERNAME',$username,time()+172800);
      }
     else
      {
      }
    }

 

That is the function here it is in use:

 

$username = mysql_real_escape_string( $_POST['username'] );
$password = mysql_real_escape_string( $_POST['password'] );

$username = strtolower($username);
$password = strtolower($password);

$username = md5($username);
$password = md5($password);

Login($username,$password);

[PFMaBiSmAd]

What have you done to troubleshoot what it is doing?

 

What does echoing both $password and $a_password show?

[pudge1]

Password shows up what it should but $a_password is empty. Sorry I forgot to mention that.

[PFMaBiSmAd]

Are your Username's actually stored using md5(), like you code implies they are?

[pudge1]

Yeah I even compared the md5s of the data that was being put into LogIn() and they matched up exactly in the database.

[Pikachu2000]

Send the query and the resulting array to the screen and see what you get.

 

$sql = "SELECT Password FROM Users WHERE Username='$username'";
$query = mysql_query($sql , $connection);
$arr = mysql_fetch_array($query);

echo $sql . '<br /><pre>';
print_r($arr);
echo '</pre>';