php 分页程序代码

php 分页程序代码

    $tempquery = mysql_query("select dpb,facejtype from zgy_member_p_d_basic where  dpb = '$city' and      facejtype like '%$keyword%' ");
  $count = mysql_num_rows( $tempquery );
  if( $count )
  {
   $page=isset($_GET['page'])?$_GET['page']:1;
   $pagesize=20;  
   $pagecount=($count % $pagesize)?(int)($count / $pagesize) +1:$count / $pagesize;  
   $page=($page>$pagecount || $page    $start=$pagesize*($page-1);
     $sql = "Select
     dpb,     
     truename,
     uid,
     sex,
     birth,
     education,
     experience,
     facejkind,
     facejtype,
     id
    from 
     zgy_member_p_d_basic
    where
     dpb = '$city' and
     facejtype like '%$keyword%' group by uid order by id desc limit $start,$pagesize";
     
   $query = mysql_query( $sql ) or die( mysql_error() );  
      
   while( $rs = mysql_fetch_array( $query ) )
   {
   ?>