【www.gdgbn.com--mysql教程】

    $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<1)?$page=1:$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 ) )
   {
   ?>
   
   .html" class="col-blu" target="_blank">
   
        $date = date("Y-m-d");
    $date1 = $rs["birth"];    
    echo sdate($date,$date1);
    
   ?>   
   
   
   
   
   
        }
    
  ?>
  
       
  

总数:/条 每页条 当前第/页 &city=&page=" class="col-blu"> 首页 &city=&page=" class="col-blu">上一页 &city=&page=" class="col-blu">下一页 &city=&page=" class="col-blu">尾页 转到 第
   
 
 
 
  页
   
 

  
 
 
 
     }
  else
  {
   ?>
     
        对不起,您要查找内容暂时不存在!
     
       }
   ?>
   
 

本文来源:http://www.gdgbn.com/shujuku/21085/