<?
include ("include/safe.inc");
include("include/config.inc");
include("include/page.php");
$result=mysql_query("select * from news");
$total=mysql_num_rows($result);
pageft($total,13);$result=mysql_query("select * from news ORDER BY `news` . `ID` DESC limit $firstcount,$displaypg ");$sn=($page-1)*$displaypg+1;
?>
<!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=gbk" />
<title>百纳新闻管理页面</title>
<link href="../style/news_list.css" rel="stylesheet" type="text/css" />
</style>
</head><body>
<script language="javascript">
<!--
function CheckAll()
{
for (var i=0;i<document.news.elements.length;i++)
{
var e = document.news.elements[i];
if (e.name != 'allbox' && e.type.toUpperCase() == "CHECKBOX")
e.checked = document.news.allbox.checked;
}}
//-->
</script><form action="del.php" name="news" method="POST" >
<table width="790" cellpadding="0" cellspacing="1" border="0" bgcolor="#B9E7FC" align="center">
<tr>
<th width="68" height="40" align="center" valign="middle">编号</th>
<th width="433" height="40" align="center" valign="middle">新 闻 标 题</th>
<th width="137" height="40" align="center" valign="middle">发布时间</th>
<th width="77" height="40" align="center" valign="middle">浏览数</th>
<th width="53" height="40" align="center" valign="middle"><a href="javascript:CheckAll();" onClick="allbox.checked=!allbox.checked" style="font-size:16px;color:#369;">全选</a><input type="hidden" name="allbox" value="Check All" onClick="CheckAll();"></th>
</tr>
<? while($news_rs = mysql_fetch_object($result))
{ echo "
<tr class='tr1' onmouseover=this.style.backgroundColor='#FEFEE1' onMouseOut=this.style.backgroundColor='#fafafa'>
<td height='30' align='center' valign='middle'>".$sn++."</td>
<td class='Ntitle' height='30' align='left' valign='middle'><a href='modify.php?Nid=".$news_rs->ID."'>".$news_rs->title."</a></td>
<td height='30' align='center' valign='middle'>".$news_rs->date."</td>
<td height='30' align='center' valign='middle'>".$news_rs->count."</td>
<td height='30' align='center' valign='middle'><input type='checkbox' name='Nid[]' value='".$news_rs->ID."' />
</td>
</tr>"; }
?>
<tr><td class="page" colspan="4" align="center"><? echo $pagenav; ?></td><td align="center" valign="middle"><input type="submit" name="button" value="删除" onclick="{if(confirm('确定删除?')){return true;}return false;}"></td><tr>
</table></form></body>
</html>出错提示为:Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in H:\BOKA\Website\localhost\baina\admin_baina\news_list.php on line 55请问这错误该如何修改才能正常显示?
include ("include/safe.inc");
include("include/config.inc");
include("include/page.php");
$result=mysql_query("select * from news");
$total=mysql_num_rows($result);
pageft($total,13);$result=mysql_query("select * from news ORDER BY `news` . `ID` DESC limit $firstcount,$displaypg ");$sn=($page-1)*$displaypg+1;
?>
<!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=gbk" />
<title>百纳新闻管理页面</title>
<link href="../style/news_list.css" rel="stylesheet" type="text/css" />
</style>
</head><body>
<script language="javascript">
<!--
function CheckAll()
{
for (var i=0;i<document.news.elements.length;i++)
{
var e = document.news.elements[i];
if (e.name != 'allbox' && e.type.toUpperCase() == "CHECKBOX")
e.checked = document.news.allbox.checked;
}}
//-->
</script><form action="del.php" name="news" method="POST" >
<table width="790" cellpadding="0" cellspacing="1" border="0" bgcolor="#B9E7FC" align="center">
<tr>
<th width="68" height="40" align="center" valign="middle">编号</th>
<th width="433" height="40" align="center" valign="middle">新 闻 标 题</th>
<th width="137" height="40" align="center" valign="middle">发布时间</th>
<th width="77" height="40" align="center" valign="middle">浏览数</th>
<th width="53" height="40" align="center" valign="middle"><a href="javascript:CheckAll();" onClick="allbox.checked=!allbox.checked" style="font-size:16px;color:#369;">全选</a><input type="hidden" name="allbox" value="Check All" onClick="CheckAll();"></th>
</tr>
<? while($news_rs = mysql_fetch_object($result))
{ echo "
<tr class='tr1' onmouseover=this.style.backgroundColor='#FEFEE1' onMouseOut=this.style.backgroundColor='#fafafa'>
<td height='30' align='center' valign='middle'>".$sn++."</td>
<td class='Ntitle' height='30' align='left' valign='middle'><a href='modify.php?Nid=".$news_rs->ID."'>".$news_rs->title."</a></td>
<td height='30' align='center' valign='middle'>".$news_rs->date."</td>
<td height='30' align='center' valign='middle'>".$news_rs->count."</td>
<td height='30' align='center' valign='middle'><input type='checkbox' name='Nid[]' value='".$news_rs->ID."' />
</td>
</tr>"; }
?>
<tr><td class="page" colspan="4" align="center"><? echo $pagenav; ?></td><td align="center" valign="middle"><input type="submit" name="button" value="删除" onclick="{if(confirm('确定删除?')){return true;}return false;}"></td><tr>
</table></form></body>
</html>出错提示为:Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in H:\BOKA\Website\localhost\baina\admin_baina\news_list.php on line 55请问这错误该如何修改才能正常显示?
$firstcount = 0;
}如果数据表为空 原先的$firstcount输出的值是-8这样当$firstcount小于0时 我就给它赋个值 这样数据表为空时就没错误提示了.问题解决,如果哪位朋友有更好的方法请一起分享..
哈哈,既然解决了,分就给我吧!