Question

这段php小程序哪里错了呀。。。。

<?
$username=$_GET["username"];
$password=$_GET["password"];
if ($username="" or $password="") exit();
$db = mysql_connect("localhost", "123","321");
mysql_select_db("bbs",$db);
$result = mysql_query("select syslogin_members where username=$username and password=$password",$db);
if (!$result->eof)
{
echo "OK!";
}
$result->Close();
?>

错误信息：
Fatal error: Call to a member function Close() on a non-object in
就是想查一下数据库里有没有对应的username/password一条数据
有的话，就输出“ok”

Answer 1

$result = mysql_query("select syslogin_members where username=$username and password=$password",$db);

改为

$result = mysql_fetch_object(mysql_query("select syslogin_members where username=$username and password=$password",$db));

Answer 2

在上面+个单引号试试
("select * from members where username='".$username."' and password='".$password."'" )