【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">=$rs["truename"]?>
$date = date("Y-m-d");
$date1 = $rs["birth"];
echo sdate($date,$date1);
?>
= $rs["sex"] ? "男" : "女" ;?>
= $rs["education"]?>
= $rs["experience"]?>
= $rs["facejkind"]?>
}
?>
}
else
{
?>
对不起,您要查找内容暂时不存在!
}
?>