一个完整的分页显示代码的例子

<?php
  $connect=mysql_connect('localhost','root','fanglin');
  mysql_select_db('userinfo',$connect);

  $page_num=10;  //每页显示的行数
  if(!isset($page_no))
     {
       $page_no=1;                //$page_no页号
     }
   $start_num=$page_num*($page_no-1);          //0         ,10
   $sql="select * from userinfo limit $start_num,$page_num";  //0,10  10,10

   $result=mysql_query($sql);
   $rows=mysql_num_rows($result);

   for($i=0;$i<$rows;$i++)
     {
      mysql_data_seek($result,$i);
      $data=mysql_fetch_array($result);
      echo "<pre>";
      echo "id:$data[id],username:$data[username],";
      echo "password: $data[password],name: $data[name]";
      echo "</pre>";

     }
     echo "<a href='fen ye display process.php?page_no=" . ($page_no - 1) ."'>上一页</a><a href='fen ye display process.php?page_no=" .($page_no + 1) ."'>下一页</a>";
?> 

注意：mysql_data_seek()与mysql_fetch_array()函数的使用