|
|
出 租 |
|
|
<%
'strsql="select top 6 * from [house_hack] where pass='是' order by id desc"
strsql="select top 6 * from [house_hack] order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open strsql,conn,3,3
%>
<%do while not rs.eof%>
" target="_blank" >
[<%=left(rs("house_name"),6)%>] <%=rs("hx")%> <%if rs("pass")="是" then%><%=rs("pay")%>(元/月)<%else%>信息审核中..<%end if%>
<%=replace(rs("date"),right(rs("date"),8),"")%> |
<%
rs.movenext
loop
rs.close%>
更多信息>>> |
|
|
|
求 租 |
|
<%
'strsql="select top 6 * from [house_hire] where pass='是' order by id desc"
strsql="select top 6 * from [house_hire] order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open strsql,conn,3,3
%>
<%do while not rs.eof%>
" target="_blank" >
[<%=rs("qy")%>] <%=rs("hx")%> <%if rs("pass")="是" then%><%=rs("min_pay")%>~<%=rs("max_pay")%>(元/月) <%else%>信息审核中..<%end if%>
<%=replace(rs("date"),right(rs("date"),8),"")%> |
<%
rs.movenext
loop%>
更多信息>>> |
|
|
|
|
|
|
|
合 租 |
|
<%
'strsql="select top 6 * from [house_hezu] where pass='是' order by id desc"
strsql="select top 6 * from [house_hezu] order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open strsql,conn,3,3
%>
<%do while not rs.eof%>
" target="_blank" >
[<%=left(rs("house_name"),6)%>] <%=rs("hx")%> <%if rs("pass")="是" then%><%=rs("pay")%>(元/月)<%else%>信息审核中..<%end if%>
<%=replace(rs("date"),right(rs("date"),8),"")%> |
|
<%rs.movenext%>
" target="_blank" > [<%=left(rs("house_name"),6)%>] <%=rs("hx")%> <%=rs("pay")%>(元/月)
<%=replace(rs("date"),right(rs("date"),8),"")%> |
<%
rs.movenext
loop%>
更多信息>>> |
|
|
|
|
|
|
|
|
|
|
|
|
出 售 |
|
|
<%
'strsql="select top 6 * from [house_sell] where pass='是' order by id desc"
strsql="select top 6 * from [house_sell] order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open strsql,conn,3,3
do while not rs.eof%>
" target="_blank" >
[<%=left(rs("house_name"),6)%>] <%=rs("hx")%> <%if rs("pass")="是" then%><%=rs("pay")%>(万)<%else%>信息审核中..<%end if%>
<%=replace(rs("date"),right(rs("date"),8),"")%> |
<%
rs.movenext
loop%>
更多信息>>> |
|
|
|
求 购 |
|
<%
'strsql="select top 6 * from [house_buy] where pass='是' order by id desc"
strsql="select top 6 * from [house_buy] order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open strsql,conn,3,3
%>
<%do while not rs.eof%>
" target="_blank" >
[<%=rs("qy")%>] <%=rs("hx")%> <%if rs("pass")="是" then%><%=rs("min_pay")%>~<%=rs("max_pay")%>(万) <%else%>信息审核中..<%end if%>
<%=replace(rs("date"),right(rs("date"),8),"")%> |
<%
rs.movenext
loop%>
更多信息>>> |
|
|
|
|
|
|
|