<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body>
<table align="center" border="0" cellpadding="2" cellspacing="0" width="95%">
<?php
include_once("conn.php");
$pn=@$_GET["pn"];
define("SIZE",6);
$pn=!empty($pn)?$pn:1;
$pre=($pn-1<=0)?1:$pn-1;
$ii=0;
$sqlnum="select count(*) from anli ";
$pntotal=floor(($sqlnum-1)/SIZE)+1;
$pre=($pn-1<=0)?1:$pn-1;
$pnext=($pn+1<$pntotal)?$pn+1:$pntotal;
$position=SIZE*($pn-1);
$sql="select * from anli limit " .$position.", SIZE ";
$rsnum=mysql_query($sqlnum,$conn);
$rs=mysql_query($sql,$conn);
while($row=mysql_fetch_array($rs,$conn))
{
$ii++;
if($ii%3==1){
echo "<tr>";
}
?>
<td width="33%" align="center">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td width="100%"><img src="admin/<?php echo $row[2];?>" width="200" height="180" border="0" /></td></tr>
<tr><td width="100%"><?php echo $row[1]; ?></td></tr>
</table>
</td>
<?php
if($ii%3==0){
echo "</tr>";
}
}
?>
<tr><td colspan="3" align="right">
<?php
if($pn==1){
echo ("<a href='anli.php?pn=1'>首页</a> <a href='anli.php?pn=$pnext'>下一页</a><a href='anli.php?pn=$pntotal'>末页</a>");
}
if($pn==$pntotal){
echo (" <a href='anli.php?pn=1'>首页</a> <a href='anli.php?pn=$pre'>上一页</a><a href='anli.php?pn=$pntotal'>末页</a>");
}
if($pn>1 && $pn<$pntotal){
echo (" <a href='anli.php?pn=1'>首页</a> <a href='anli.php?pn=$pre'>上一页</a><a href='anli.php?pn=$pnext'>下一页</a><a href='anli.php?pn=$pntotal'>末页</a>");
}
?></td> </tr>
</table>
</body>
</html>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\hunning\anli.php on line 99line 99 就是 while($row=mysql_fetch_array($rs,$conn)) 这是怎么回事啊?
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body>
<table align="center" border="0" cellpadding="2" cellspacing="0" width="95%">
<?php
include_once("conn.php");
$pn=@$_GET["pn"];
define("SIZE",6);
$pn=!empty($pn)?$pn:1;
$pre=($pn-1<=0)?1:$pn-1;
$ii=0;
$sqlnum="select count(*) from anli ";
$pntotal=floor(($sqlnum-1)/SIZE)+1;
$pre=($pn-1<=0)?1:$pn-1;
$pnext=($pn+1<$pntotal)?$pn+1:$pntotal;
$position=SIZE*($pn-1);
$sql="select * from anli limit " .$position.", SIZE ";
$rsnum=mysql_query($sqlnum,$conn);
$rs=mysql_query($sql,$conn);
while($row=mysql_fetch_array($rs,$conn))
{
$ii++;
if($ii%3==1){
echo "<tr>";
}
?>
<td width="33%" align="center">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td width="100%"><img src="admin/<?php echo $row[2];?>" width="200" height="180" border="0" /></td></tr>
<tr><td width="100%"><?php echo $row[1]; ?></td></tr>
</table>
</td>
<?php
if($ii%3==0){
echo "</tr>";
}
}
?>
<tr><td colspan="3" align="right">
<?php
if($pn==1){
echo ("<a href='anli.php?pn=1'>首页</a> <a href='anli.php?pn=$pnext'>下一页</a><a href='anli.php?pn=$pntotal'>末页</a>");
}
if($pn==$pntotal){
echo (" <a href='anli.php?pn=1'>首页</a> <a href='anli.php?pn=$pre'>上一页</a><a href='anli.php?pn=$pntotal'>末页</a>");
}
if($pn>1 && $pn<$pntotal){
echo (" <a href='anli.php?pn=1'>首页</a> <a href='anli.php?pn=$pre'>上一页</a><a href='anli.php?pn=$pnext'>下一页</a><a href='anli.php?pn=$pntotal'>末页</a>");
}
?></td> </tr>
</table>
</body>
</html>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\hunning\anli.php on line 99line 99 就是 while($row=mysql_fetch_array($rs,$conn)) 这是怎么回事啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货