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.
 
                    
                     
                    
                 
                    
                
 
 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号