<?php
if ($page){
$page_size=20;
$result=mysql_query($query);
#$message_count=mysql_result($result,0,"total");
$message_count=10;
$page_count=ceil($message_count/$page_size);
$offset=($page-1)*$page_size;
$query=$query." order by date desc limit $offset, $page_size";
$result=mysql_query($query);
if($result){
$rows=mysql_num_rows($result);
if($rows!=0){
while($myrow=mysql_fetch_array($result)){
echo "<tr>";
echo "<td width='15' height='12'><img src=http://www.webjx.com/image/home2.gif width='14' height='14'></td>";
echo "<td width='540' height='12'>$myrow[id]&nbsp;$myrow[tradetype]&nbsp;$myrow[address]&nbsp;$myrow[wuye]($myrow[housetype])<font style='font-size:9pt'>[$myrow[date]]</font>";
echo "</td>";
echo "<td width='75' height='12'><a href='view_d.php?code=$myrow[code]' target='_blank'>详细内容</a></td>";
echo "</tr>";
}
}
else echo "<tr><td><div align='center'><img src=http://www.webjx.com/image/sorry.gif><br><br>没有找到满足你条件的记录</div></td></tr>";
}
$prev_page=$page-1;
$next_page=$page+1;
echo "<div align='center'>";
echo "&nbsp;第".$page."/".$page_count."页&nbsp";
if ($page<=1){
echo "第一页";
}
else{
echo "<a href='$PATH_INFO?page=1'>第一页</a>";
}
echo " ";
if ($prev_page<1){
echo "上一页";
}
else{
echo "<a href='$PATH_INFO?page=$prev_page'>上一页</a>";
}
echo " ";
if ($next_page>$page_count){
echo "下一页";
}
else{
echo "<a href='$PATH_INFO?page=$next_page'>下一页</a>";
}
echo " ";
if ($page>=$page_count){
echo "最后一页";
}
else{
echo "<a href='$PATH_INFO?page=$page_count'>最后一页</a>";
}
echo "</div>";
}
else{
echo "<p align='center'>现在还没有房屋租赁信息!</p>";
}
echo "<hr width="100%" size="1">";
?>
</table>