$str="select * from $table where username='".$name."' order by post_time 这一句有疑问,我刚才试了一下,将其中的数据库替换成我自己的,也是这里出错,然后我修改成这样就可以了: $str="select * from $table where lastposter='".$name."' order by forumid desc"; (其中的数据结构是以我的数据库为参考), 因此请检查你的数据库的结构是否与这条语句所写的符合,或贴出来大家参考一下。
$str="select * from ".$table." where username='".$name."' order by post_time";
出现这样的提示一般是 sql语句出错。仔细检查一下$str.
我说:楼主能否贴出数据库的结构来,我怀疑你的表里面有无phst_time这个域
$str="select * from $table where username='".$name."' order by post_time desc"; 改成 $str="select * from $table where username='$name' order by post_time desc";
include "share.inc.php";
if(($name!=$adminname)||($pass!=$adminpass))
{
$strsql="select * from user where username='".$name."' and password='".$pass."'";
$result=mysql_query($strsql,$connect);
if(!($arr=mysql_fetch_array($result)))
{
header("location:login.php");
exit();
}}
echo "<table width=\"81%\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#99CCCC\">";
echo "<tr><td bgcolor=\"ffffff\">";
include "head.inc.php";
echo "</td></tr><tr><td bgcolor=\"#ffffff\">";
?>
<table width="100%">
<tr>
<td>●<a href="news.php" title="到新闻系统前台">在线新闻系统</a>>>>新闻列表(新闻管理)</td>
<td align="right">●
<?
print "<a href=\"addnews.php?name=$name&pass=$pass\">添加新闻</a>";
if (@$name==$adminname)
{
echo "<td align=\"right\">●<a href=\"adduser.php?user=$name&pass=$pass\" >添加用户</a></td>";
echo "<td align=\"right\">●<a href=\"deluser.php?user=$name&pass=$pass\" >删除用户</a></td>";
}
?></td>
</tr>
</table>
<?php echo "</td></tr><tr><td bgcolor=\"#FFFFFF\">"; ?>
<table width="100%" cellspacing="1">
<tr bgcolor="#99CCFF">
<td width="10%" align="center">张贴日期</td>
<td width="66%" align="center">新闻主题</td>
<td width="6%" align="center">图片</td>
<td width="6%" align="center">编辑</td>
<td width="6%" align="center">删除</td>
<td width="6%" align="center">审核</td>
</tr>
<?
$MAXROWS=10;
$str="select * from $table where username='".$name."' order by post_time desc";
if(isset($from)){
$step=$total-$from;
$step=$step>$MAXROWS?$MAXROWS:$step;
$str="$str limit $from,$step";
$res=mysql_db_query($database,$str,$connect);
for($i=0;$i<$step;$i++){
$row=mysql_fetch_row($res);
print "<tr bgcolor=\"#F5F5FE\">";
print "<td width=\"10%\" align=\"center\">".$row[5]."</td>";
print "<td width=\"66%\" align=\"center\"><a href=\"news_view.php?news_id=$row[0]\">".$row[1]."</a></td>";
if($row[6])
print "<td width=\"6%\" align=\"center\">有</td>";
else print "<td width=\"6%\" align=\"center\">无</td>";
print "<td width=\"6%\" align=\"center\"><a href=\"editnews.php?news_id=$row[0]&name=$name&pass=$pass\"><img src=\"modify.gif\" border=0 alt=修改此新闻></a></td>";
print "<td width=\"6%\" align=\"center\"><a href=\"delnews.php?news_id=$row[0]&name=$name&pass=$pass\"><img src=\"trash.gif\" border=0 alt=删除此新闻></a></td>";
if(!$row[8])
print "<td width=\"6%\" align=\"center\"><a href=\"checknews.php?news_id=$row[0]&name=$name&pass=$pass\">通过</a></td>";
else
print "<td width=\"6%\" align=\"center\">OK</td>";
print "</tr>";
}
print "</table>";
echo "</td></tr></table>";
print"<br><div align=\"center\"><a href=\"$PHP_SELF?from=0&total=$total&pages=$pages&name=$name&pass=$pass\">";
print"首页</a> ";
if ($pages>2&&$from>=$MAXROWS){
print"<a href=\"$PHP_SELF?from=";
print ($from-$MAXROWS)."&total=$total&pages=$pages&name=$name&pass=$pass\">";
print"上一页</a> ";
}
if($from+$MAXROWS<$total){
print"<a href=\"$PHP_SELF?from=";
print ($from+$MAXROWS)."&total=$total&pages=$pages&name=$name&pass=$pass\">";
print"下一页</a> ";
}
print"<a href=\"$PHP_SELF?from=";
print($pages*$MAXROWS-$MAXROWS)."&total=$total&pages=$pages&name=$name&pass=$pass\">末页</a></div>";
}
else{
@$res=mysql_db_query($database,$str,$connect);
$total=mysql_num_rows($res);
$step=$total>$MAXROWS?$MAXROWS:$total;
$pages=ceil($total/$MAXROWS);
for ($i=0;$i<$step;$i++){
$row=mysql_fetch_row($res);
print "<tr bgcolor=\"#F5F5FE\">";
print "<td width=\"10%\" align=\"center\">".$row[5]."</td>";
print "<td width=\"66%\" align=\"center\"><a href=\"news_view.php?news_id=$row[0]\">".$row[1]."</a></td>";
if($row[6])
print "<td width=\"6%\" align=\"center\">有</td>";
else print "<td width=\"6%\" align=\"center\">无</td>";
print "<td width=\"6%\" align=\"center\"><a href=\"editnews.php?news_id=$row[0]&name=$name&pass=$pass\"><img src=\"modify.gif\" border=0 alt=修改此新闻></a></td>";
print "<td width=\"6%\" align=\"center\"><a href=\"delnews.php?news_id=$row[0]&name=$name&pass=$pass\"><img src=\"trash.gif\" border=0 alt=删除此新闻></a></td>";
if(!$row[8])
print "<td width=\"6%\" align=\"center\"><a href=\"checknews.php?news_id=$row[0]&name=$name&pass=$pass\">通过</a></td>";
else
print "<td width=\"6%\" align=\"center\">OK</td>";
print "</tr>";
}
print "</table>";
echo "</td></tr></table>";
if ($pages>1){
print"<br><div align=\"center\"><a href=\"$PHP_SELF?from=0&total=$total&pages=$pages&name=$name&pass=$pass\">";
print"首页</a> ";
}
if ($pages>2){
print"<a href=\"$PHP_SELF?from=$step&total=$total&pages=$pages&name=$name&pass=$pass\">";
print"下一页</a> ";
}
if ($pages>=2){
print"<a href=\"$PHP_SELF?from=";
print($pages*$MAXROWS-$MAXROWS)."&total=$total&pages=$pages&name=$name&pass=$pass\">末页</a></div>";
}
}
print "<HR color=#E3E3E3 noshade width=80% size=1>";
include "foot.inc.php";
?>
这是share.inc.php的源代码:<?
$hostname="localhost";
$username="root";
$password="";
$database="enews";
$table="news";
$adminname="boss";
$adminpass="9001tyh";
//以下如果不熟悉,请不要自行修改
@$connect=mysql_connect($hostname,$username,$password)
or die('不能连接到服务器!');
@$select_db=mysql_select_db($database,$connect)
or die('连接数据库失败!');
?>
@$res=mysql_db_query($database,$str,$connect);
$total=mysql_num_rows($res);(第86行)
$step=$total>$MAXROWS?$MAXROWS:$total;
$pages=ceil($total/$MAXROWS);
这一句有疑问,我刚才试了一下,将其中的数据库替换成我自己的,也是这里出错,然后我修改成这样就可以了:
$str="select * from $table where lastposter='".$name."' order by forumid desc";
(其中的数据结构是以我的数据库为参考),
因此请检查你的数据库的结构是否与这条语句所写的符合,或贴出来大家参考一下。
把前面的@去掉,看看报的是什么错
改成
$str="select * from $table where username='$name' order by post_time desc";
$res=@mysql_db_query($database,$str,$connect);
$total=@mysql_num_rows($res);(第86行)
$step=$total>$MAXROWS?$MAXROWS:$total;
$pages=ceil($total/$MAXROWS);