php分页显示文章列表
<div class="content"> <ul> <?php $querySel = "select * from news where ClassID ='".$lid."' and DShow=1 order by Addtime desc"; $result = mysql_query($querySel) or die(mysql_error()); $total_records = mysql_num_rows($result); //取得总记录数 $page_size = 12; //每页显示的条数 $nums = $total_records; //总条目数 $sub_pages = 5; //每次显示的页数 $pageCurrent = $_GET["page"]; //得到当前是第几页 if(!$pageCurrent) $pageCurrent = 1; //$begin_record = 0; //显示记录的首行序号 $begin_record = ($pageCurrent - 1) * $page_size; if($total_records> 0) { //利用LIMIT关键字获取本页所要显示的记录,注意limit两边要"空格"; $querySel = $querySel. " limit ".$begin_record. ", ".$page_size; $result = mysql_query($querySel) or die(mysql_error()); $current_records = mysql_num_rows($result); //取得本页的记录总数 //将查询结果放在$result_show 数组 $result_show = array(); } $i = 0; while($row=mysql_fetch_array($result)) { $result_show[$i] = $row; ?> <li><a href="NewsInfo.php?id=<?php echo $result_show[$i]['ID'] ?>" target="_blank" class="tmain"><?php echo ($result_show[$i]['Tit']) ?></a><span class="riqi"><?php echo date('Y-m-d', strtotime($result_show[$i]['Addtime'])); ?></span></li> <?php } ?> </ul> <div class="pageclass"><?php $subPages=new SubPages($page_size,$nums,$pageCurrent,$sub_pages,"list.php?id=".$lid."&page=",2);?></div> </div>
----------------
Lynx
The quieter you become,the more you are able to hear.