![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
我在使用mysql_fetch_row()函数时,出现了下面的警告:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\myweb\main.php on line 9
但是,前面的mysql_start(), mysql_pconnect(), mysql_db_select(), 都没有报出错。因为是第一次用,不知道是否在配置上有问题,请高手指点一下,谢谢!
<?
session_start();
$db_conn = mysql_pconnect("localhost", "root", "");
mysql_select_db("member", $db_conn);
$query = "select * from member "
."where name = '$name' and password = '$password'";
$result = mysql_db_query($query, $db_conn);
if ($row = mysql_fetch_row($result))
{
//如果name和password在数据库中,注册该用户的ID
$valid_user = $row->ID;
session_register("$valid_user");
}
if (session_is_registered("$valid_user"))
{
?>
<script>
alert("注册成功,欢迎访问数据库");
</script>
<?
}
else
{
?>
<script>
alert("用户名和密码不正确");
</script>
<?
}
?>

