How to use PHP to generate html paginated list

<?php 
$db = mysql_connect("127.0.0.1","root","*******") or die("cant&#39;t connect host"); 
$re = mysql_select_db("t",$db)or die ("can&#39;t open database"); 
$sql = "Select * FROM news"; 
$res = mysql_query($sql); 
$row = mysql_num_rows($res); 
$pagesize   = 2;                   //分页 
行数 
if($row<$pagesize) $pages = 1;         
if($row%$pagesize){ 
    $pages  = intval($row/$pagesize)+1; 
}else{ 
    $pages  = intval($row/$pagesize); 
} 
for($i=1;$i<=$pages;$i++){ 
    $page_turn=""; 
    if($i==1){ 
        $indexpath="index.html"; 
        $page_turn.="First | Front"; 
    }else{ 
        $indexpath="index_".$i.".html"; 
        $page_turn.="<a href=&#39;index.html&#39;>First</a> | <a href=&#39;index_".($i-1).".html&#39;>Front</a>"; 
    } 
    if($i==$pages){ 
        $page_turn.=&#39; | Behind | Last&#39;; 
    }else{ 
        $page_turn.=" | <a href=&#39;index_".($i+1).".html&#39;>Behind</a> | <a href=&#39;index_".$pages.".html&#39;>Last</a>"; 
    } 
    $search = $sql." LIMIT ".($i-1)*$pagesize .", $pagesize";  
    $result = mysql_query($search); 
    $rows   = mysql_num_rows($result);     
    $j=1; 
    $list=""; 
    while($j<=$rows){ 
        $doc    = mysql_fetch_array($result); 
        $id     = $doc[&#39;0&#39;]; 
        $title  = $doc[&#39;1&#39;]; 
        $path   = $doc[&#39;3&#39;]; 
        $list   .="<a href=&#39;".$id.".html&#39;>".$title."</a><br>"; 
        $j+=1; 
    } 
    $list.="<br><br>".$page_turn; 
    $fp     = fopen("html/list.html","r"); 
    $str    = fread($fp,filesize("html/list.html"));   
    $str    = str_replace("{content}",$list,$str); 
    fclose($fp); 
    $handle = fopen($path."/".$indexpath,"w"); 
    fwrite($handle,$str); 
    fclose($handle);     
}        
    copy($path."/index.html",$path."/index_1.html");            
?>