<?php
$sql="select * from fzf where id<>'' and address like "%岳麓%" and address like "%小区%" and m2>=50 ";
?><?
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
}
$page_size = 12; // 每页数量
// 获取总数据量
$sql = " $sql ";
$result = mysql_query($sql);
$amount = mysql_num_rows($result);
//$amount = $row['amount']; // 记算总共有多少页
if( $amount ){
if( $amount < $page_size ){ $page_count = 1; }
if( $amount % $page_size ){
$page_count = (int)($amount / $page_size) + 1;
}else{
$page_count = $amount/$page_size;
}
}
else{
$page_count = 0;
}
// 翻页链接
$page_string = '';
if( $page == 1 ){
$page_string .= '首页 上一页 ';
}
else{
$page_string .= '<a href=?page=1>首页</a> <a href=?page='.($page-1).'>上一页</a> ';
}
if( ($page == $page_count) || ($page_count == 0) ){
$page_string .= '下一页 尾页';
}
else{
$page_string .= '<a href=?page='.($page+1).'>下一页</a> <a href=?page='.$page_count.'>尾页</a>';
}
// 获取数据,以二维数组格式返回结果
if( $amount ){
$sql = " $sql order by photo desc,time desc ". ($page-1)*$page_size .", $page_size";
$result = mysql_query($sql);
while($ds=mysql_fetch_object($result)) //就是这行报错!!!!!!!!!!!!!!!!
{
?>
$sql="select * from fzf where id<>'' and address like "%岳麓%" and address like "%小区%" and m2>=50 ";
?><?
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
}
$page_size = 12; // 每页数量
// 获取总数据量
$sql = " $sql ";
$result = mysql_query($sql);
$amount = mysql_num_rows($result);
//$amount = $row['amount']; // 记算总共有多少页
if( $amount ){
if( $amount < $page_size ){ $page_count = 1; }
if( $amount % $page_size ){
$page_count = (int)($amount / $page_size) + 1;
}else{
$page_count = $amount/$page_size;
}
}
else{
$page_count = 0;
}
// 翻页链接
$page_string = '';
if( $page == 1 ){
$page_string .= '首页 上一页 ';
}
else{
$page_string .= '<a href=?page=1>首页</a> <a href=?page='.($page-1).'>上一页</a> ';
}
if( ($page == $page_count) || ($page_count == 0) ){
$page_string .= '下一页 尾页';
}
else{
$page_string .= '<a href=?page='.($page+1).'>下一页</a> <a href=?page='.$page_count.'>尾页</a>';
}
// 获取数据,以二维数组格式返回结果
if( $amount ){
$sql = " $sql order by photo desc,time desc ". ($page-1)*$page_size .", $page_size";
$result = mysql_query($sql);
while($ds=mysql_fetch_object($result)) //就是这行报错!!!!!!!!!!!!!!!!
{
?>
$sql = " $sql order by photo desc,time desc limit ". ($page-1)*$page_size .", $page_size";
echo $sql;
/*$result = mysql_query($sql);
while($ds=mysql_fetch_object($result)) //就是这行报错!!!!!!!!!!!!!!!!
{ */