comparing a password md5 php/mysql
$rslt['password'] = md5($mypassword)
$rslt['password'] == md5($mypassword)
$rslt['password'] === md5($mypassword)

if((mysql_num_rows($qry)==1)&&($rslt['username']==$myusername)&&($rslt['password'] == md5($mypassword)))
    {
    echo $rslt['username'];
    echo $myusername;
    echo $rslt['password'];
    echo md5($mypassword);
    //$expire=time()+60*60*24*30;
    //$_SESSION['user'] = $rslt['username'];
    //header("location: ../acct_beta.php");
    }

select count(*) from <table> where username = @username and password = MD5(@password)