关于多表查询的分页显示 ?

<?php
    include "page.php";
 ?>
<html>
<head>
<title>搜索</tite>
</head>
<body>
<?php
    include "sousuo.php";
    include "sousuo_pages.php";
?>
</body>
</html>
这是总代码?
这是 page.php代码<?php
//没页显示记录数
$PageSize =3;
$StartRow =0;  //开始显示记录的编号 //获取需要显示的页数，由用户提交
if(empty($_GET['PageNo'])){  //如果为空，则表示第1页
    if($StartRow == 0){
        $PageNo = $StartRow + 1;  //设定为1
    }
}else{
    $PageNo = $_GET['PageNo'];  //获得用户提交的页数
    $StartRow = ($PageNo - 1) * $PageSize +1;  //获得开始显示的记录编号
}//因为显示页码的数量是动态变化的
//假如总共有一百页，则不可能同时显示100个链接
//而是根据当前的页数显示一定数量的页面链接
//设置显示页码的初始值
if($PageNo % $PageSize == 0){
    $CounterStart = $PageNo - ($PageSize - 1);
}else{
    $CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
}//显示页码的最大值
$CounterEnd = $CounterStart + ($PageSize - 1);
?>
这是sousuo.php代码
<?php
  include "../dbConnection.php";
  $search=trim($_POST['search']);
  //echo $search;
  if($search!="")
    {  $news_mysql="select * from news_purpose_table where title like'%$search%' or content like '%$search%'";
       $reading_mysql="select * from product_reading_table where topic like '%$search%' or content like '%$search%' or product_name='%$search%'";
          
       //echo "<br>".$news_mysql."<br>";
        $news_result=mysql_query($news_mysql) or die(mysql_error());
        $news_num=mysql_num_rows($news_result);
        //$reading_result=mysql_query($reading_mysql) or die(mysql_error());
        //$reading_num=mysql_num_rows($reading_result);
         $sum=$news_num+$reading_num;
         echo "搜索结果:";
         echo "你搜索的关键字是<font color=red>".$search."</font>,共".$sum."条记录!";
        //echo $sum;
        //echo "check $search sum $news_num tiao jilu";
        //echo "cheng gong!"."<br>";          //获取总记录数
          $RecordCount =$sum;         //获取总页数
          $MaxPage = $RecordCount % $PageSize;
         if($RecordCount % $PageSize == 0){
               $MaxPage = $RecordCount / $PageSize;
            }else{
                 $MaxPage = ceil($RecordCount / $PageSize);
             }
        
        //echo $row;
      if($news_num!=0)
      {
       while($row=mysql_fetch_array($news_result))
           {  $str=substr(trim($row[content]),0,100); 
            echo "<table border=0 cellspacing=0 cellpadding=0><tr><td align=left><a href=sousuoneirong.php?id=$row[id] target='_blank'>$row[title]</a></td></tr><tr><td align=left>$str......</td></tr></table>";
            }
      }
      if($reading_num!=0){
        while($rows=mysql_fetch_array($reading_result))
           {    
                $string=substr(trim($rows[content]),0,100);
               echo "<table border=0 cellspacing=0 cellpadding=0><tr><td align=left><a href=sousuoneirong.php?id2=$rows[id] target='_blank'>$rows[topic]</td></tr><tr><td align=left>$string......</td></tr></table>";
           }
        
        } 
     /* if($function_num!=0){
         while($rrow=mysql_fetch_array($function_result))
           {
              $fstr=substr(trim($rrow[function_content]),0,100);
              //echo $fstr;
              echo "<table border=0 cellsapcing=0 cellpadding=0><tr><td align=left><a href=show.php?id=$rrow[id]>$rrow[function_topic]</a></td></tr><tr><td align=left>$first.....</td></tr></table>";
            }
          
        }
*/
         
     }else {
                 echo "请输入关键字!";
           }
?>
这是 sousuo_pages.php 代码
<?php
         echo "<table align=center>";
         echo " 共 $MaxPage 页 &nbsp;&nbsp";
 // echo "<font size=4>";
        //显示第一页或者前一页的链接
//如果当前页不是第1页，则显示第一页和前一页的链接
        if($PageNo != 1){
            $PrevStart = $PageNo - 1;
            print "<a href=search.php?PageNo=1>首页</a>: ";
            print "<a href=search.php?PageNo=$PrevStart>前一页</a>";
        }
  print " [ ";
        $c = 0;



        //打印需要显示的页码
        for($c=$CounterStart;$c<=$CounterEnd;$c++){
            if($c < $MaxPage){
                if($c == $PageNo){
                    if($c % $PageSize == 0){
                        print "$c ";
                    }else{
                        print "$c ,";
                    }
                }elseif($c % $PageSize == 0){
                    echo "<a href=search.php?PageNo=$c>$c</a> ";
                }else{
                    echo "<a href=search.php?PageNo=$c>$c</a> ,";
                }//END IF
            }else{
                if($PageNo == $MaxPage){
                    print "$c ";
                    break;
                }else{
                    echo "<a href=search.php?PageNo=$c>$c</a> ";
                    break;
                }//END IF
            }//END IF
       }//NEXT      echo "] ";         if($PageNo < $MaxPage){  //如果当前页不是最后一页，则显示下一页链接
          $NextPage = $PageNo + 1;
          echo "<a href=search.php?PageNo=$NextPage>下一页</a>";
      }
      
      //同时如果当前页补上最后一页，要显示最有一页的链接
      if($PageNo < $MaxPage){
       $LastRec = $RecordCount % $PageSize;
        if($LastRec == 0){
            $LastStartRecord = $RecordCount - $PageSize;
        }
        else{
            $LastStartRecord = $RecordCount - $LastRec;
        }        print " : ";
        echo "<a href=search.php?PageNo=$MaxPage>尾页</a>";
        }
echo "</font>";
         echo "</table>";
     mysql_free_result($result);
    mysql_free_result($TRecord);
 
    ?>