Warning:mysql_fetch_row():suppliedargumentisnotavalidMySQLresultresourceinE:\WAMP\Apache\htdocs\experience\connect.phponline11急求!!!运行mysql_fetch_array,也显示警告。...
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\WAMP\Apache\htdocs\experience\connect.php on line 11
急求!!!运行mysql_fetch_array,也显示警告。急求!!
在这个程序中是报错的,
$conn=mysql_connect('localhost','root','725091190527liha')
or die('连接失败');
mysql_select_db('PXSCJ',$conn)
or die('数据库失败');
mysql_query('SET NAMES gb2312');
$sql="select * form XSB where 学号='081101'";
$result=mysql_query($sql);
echo"
echo"
学号姓名总学分";while($row=mysql_fetch_row($result))
{
list($XH,$XM,$XB,$CSSJ,$ZY,$ZXF,$BZ)=$row;
echo "
$XH$XM$ZXF";}
echo"
";?>
而在下面的这个程序是对的
$conn=mysql_connect('localhost','root','725091190527liha')
or die('连接失败');
mysql_select_db('PXSCJ',$conn)
or die('选择数据库失败');
mysql_query("SET NAMES gb2312");
$sql="select * from XSB where 学号='081101'";
$result=mysql_query($sql);
if($row=mysql_fetch_assoc($result))
print_r($row);
?>
这是为什么呢???
展开