|
|
<% set rs=server.createobject("adodb.recordset")
sql="SELECT top 4 id,s_housearea,s_housename,s_houseadd,s_househuxin01,s_housemj,s_houseprice FROM house where s_myclass='民宅' and sfzqtxs_tm='1' order by postdatetime desc"
rs.open sql,conn,3,2
do while not rs.eof
%>
| |
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
|
| |
|
|
<% set rs=server.createobject("adodb.recordset")
sql="SELECT top 5 id,s_housearea,s_housename,s_houseadd,s_househuxin01,s_housemj,s_houseprice FROM house where s_myclass='公寓' and sfzqtxs_tm='1' order by postdatetime desc"
rs.open sql,conn,3,2
do while not rs.eof
%>
| |
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
|
|
|
|