阿林匹司
新手上路
UID 75297
精华
0
积分 35
帖子 21
金钱 35 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2006-6-21
状态 离线
|
[广告]: 代充Paypal帐号美元
[求助]关于MYSQL问题
环境：php5.1.4 MYSQL5.023 Apache2.0.58
code:
<?php
session_start();
session_register('user');
session_register('password');
session_register('authoritg');
session_register('offices');
session_register('zhiwei');
session_register('ye');
//session_register('$user');
$ye=1;
//echo "<?xml version=\"1.0\" encoding=\"gb2312\"?".">";
//session_set_save_handler("login_office","user_id","user_author");
$user=$_POST['username'];
$pass_word=$_POST['password'];
//$user=$user_name;
$link_id=mysql_connect('localhost','root','root');
$dbase=mysql_select_db('pro_mg_st');
$query="SELECT * FROM 'login' WHERE username='".$user."' and password='".$pass_word."'";
$result=mysql_query($query);
$num_records=mysql_num_rows($result);
echo $num_records;
//$login_row=mysql_fetch_array($result);
/*
if($num_records)
{
$record=mysql_fetch_object($result);
$username=$record->username;
$password=$record->password;
$authoritg=$record->authoritg;
$offices=$record->offices;
$zhiwei=$record->zhiwei;
//if($username=="admins")
// echo '<meta http-equiv="Refresh" content="0; url=tianjia.php">';
echo '<meta http-equiv="Refresh" content="0; url=zhuye.php">';
//$login_office=$login_row[4];
//$user_id=$login_row[0];
//$user_author=$login_row[3];
// if($user_author=="A")
// { echo '<meta http-equiv="Refresh" content="0; url=main.php">'; }
//else
// { echo '<meta http-equiv="Refresh" content="0; url=mainc.php">'; }
}
else
{
echo '<script language="javascript">alert("用户名或密码错误！")</script>';
echo '<meta http-equiv="Refresh" content="0; url=index.php">';
}
*/
?>
运行提示： Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Apache2\htdocs\dearhyp\register.php on line 22
是那里写得不对
还有一个就是为什么不能这样写，以前的老版本就没有问题：
code: $query="SELECT * FROM login WHERE username='$user' and password='$pass_word'";
|
|
