require('connect.php');
include('head.php');
$sql="select distinct (firstMesID) from user";
$result=mysql_query($sql,$con);
$num=mysql_num_rows($result);
$page_size=20;
if($num<=$page_size){
$page_count=1;
}
if($num%$page_size){
$page_count=(int)($num/$page_size)+1;
}else{
$page_count=$num/$page_size;
}
if(isset($_GET['page'])){
$page=intval($_GET['page']);
}else{
$page=1;
}
echo "
"; if($page_count>1){ echo "页数:"; for($j=1;$j<=$page_count;$j++){ if($j==$page){ echo "$j "; } else{ echo "$j"; } } echo " |
}
echo "
";$sqlpage="select * from user where lastMesID is null order by id desc limit ".($page-1)*$page_size.",$page_size";
$re_page=mysql_query($sqlpage,$con) or die ("查询数据库失败:".mysql_error());
echo "
echo "
标题";echo "
作者";echo "
发帖时间";echo "
回复次数";while($row=mysql_fetch_array($re_page)){
$len=strlen($row['content']);
$reply_sql="select * from user where firstMesID='$row[id]'";
$reply=mysql_query($reply_sql,$con);
$all_times=mysql_num_rows($reply);
$reply_times=$all_times-1;
echo "
$row[title] ($len 字节)";echo "
$row[username]";echo "
$row[posttime]";echo "
$reply_times";}
echo "
";echo "
"; if($page_count>1){ echo "页数:"; for($j=1;$j<=$page_count;$j++){ if($j==$page){ echo "$j "; } else{ echo "$j>"; } } echo " |
}
?>
为什么没反应啊?求大神解答,救急!
展开