'selectid=request.form("select")
sql="select * from bazhu Where xz='出 售' or xz='求 购' "
if city<>"" then
sql=sql&"And city like '%"&city&"%' "
End if
if house_type<>"" then
sql=sql&"And house_type like '%"&house_type&"%' "
End if
if price_beg<>"" then
sql=sql&"And price_beg like '%"&price_beg&"%' "
End if
if price_end<>"" then
sql=sql&"And price_end like '%"&price_end&"%' "
End if
if living_room<>"" then
sql=sql&"And living_room like '%"&living_room&"%' "
End if
if sitting_room<>"" then
sql=sql&"And sitting_room like'%"&sitting_room&"%' "
End if
if toilet<>"" then
sql=sql&"And toilet like'%"&toilet&"%' "
End if
sql=sql & "order by id desc"
set rs=server.createobject("ADODB.recordset")
'sql="select * from bazhu where xz='出 售' or xz='求 购'"
rs.open sql,conn,1,1
'end if
if rs.eof or rs.bof then
response.write "对不起,没有查询到您需要的内容!"
response.end
end if
rs.pagesize=20
if request.querystring("page")="" then
rs.absolutepage=1
else
rs.absolutepage=request.querystring("page")
end if
%>