Question

$row = mysql_fetch_array($res);为什么总是说他错，错在哪里了

<?php $zhanghao=$_GET['zhanghao'];
$pasw=$_GET['pasw'];
$username = $_GET['name']; $conn=mysql_connect("127.0.0.1","root","123456");
if(!$conn)
die("error1");

if(!mysql_select_db("xiaoyoulu",$conn))
die("error2");$sql=mysql_query("select * from huiyuan where zhanghao='$zhanghao' limit 1");
$result=mysql_num_rows($sql);
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
if(!$pasw == $row["pasw"])
{
echo "<script> alert('用户登陆失败！请重新登陆');</script>";
echo "<script> window.location='denglu.php';</script>";
exit;
}
$_SESSION["userid"] = $row["zhanghao"];
$_SESSION["username"] = $username;
echo "<script> alert('用户登陆成功！');</script>";
echo "<script> window.location='index.php';</script>";?>

Answer 1

mysql_query没必要用2次，mysql_fetch_array mysql_num_rows在这里是一样的。所以也没必要用2次。

Answer 2

当记录集$res为空时，mysql_fetch_array()会执出错误