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 ) )
{
?>
$date = date("Y-m-d");
$date1 = $rs['birth'];
echo sdate($date,$date1);
?>
}
?>
}
else
{
?>
}
?>
