为什么我这个登陆表单不能登陆？

登陆表单是这样：login.php
<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<form action="checklogin.php" method="post"><td align="center" valign="middle"><table width="400" border="0" cellpadding="5" cellspacing="1" colspan="2"><div align="center">Administrators Login</div></td>
</tr>
<tr align="center">Username</div></td>
<td><div align="center">
<input name="username" type="text" id="username">
</div></td>
</tr>
<tr align="center">assword</div></td>
<td><div align="center">
<input name="password" type="password" id="password">
</div></td>
</tr>
<tr colspan="2"><div align="center">
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Clear">
</div></td>
</tr>
</table></td></form>
</tr>
</table>


处理文件是这样checklogin.php
<?
require_once('conn.php');
session_start();
$username=$_POST['username'];
$password=$_POST['password'];
$exec="select * from admin where username='".$username."'";
if($result=mysql_query($exec))
{
if($rs=mysql_fetch_object($result))
{
if($rs->password==$password)
{
$_SESSION['adminname']=$username;
header("location:index.php");
}
else
{
echo "<script>alert('Password Check Error!');location.href='login.php';</script>";
}
}
else
{
echo "<script>alert('Username Check Error!');location.href='login.php';</script>";
}
}
else
{
echo "<script>alert('Database Connection Error!');location.href='login.php';</script>";
}

?>


conn.php是这样：
<?
$conn=mysql_connect ("127.0.0.1", "", "");
mysql_select_db("定义的数据库");
?>

有什么提示?

Password Check Error 然后又跳到登陆页了。老大快帮偶看看

那肯定就是这个条件不成立
if($rs->password==$password)

你先echo一下 $rs->password;
看看它的值是什么