| 在售/待售楼盘 |
| 县城楼盘 |
|
 |
|
<%
dim rst2,sqlt2
set rst2=server.createobject("adodb.recordset")
sqlt2="select * from comp where icheck=True and city='武鸣县城' "
sqlt2=sqlt2 & " order by id desc "
rst2.open sqlt2,conn,1,1
j=1
%>
<%
do while not rst2.eof
%>
|
<%if j mod 4 = 0 then%>
<%
end if
rst2.movenext
j=j+1
loop
rst2.close
set rst2=nothing
%>
|
|
| 东盟经开区 |
|
|
|
<%
dim rst3,sqlt3
set rst3=server.createobject("adodb.recordset")
sqlt3="select * FROM comp where icheck=True and city='东盟经开区'"
'sqlt3=sqlt3 & "or xkz like"&"'%少量销售%'"&""
sqlt3=sqlt3 & "order by id desc"
rst3.open sqlt3,conn,1,1
n=1
%>
<%
do while not rst3.eof
%>
|
<%if n mod 4 = 0 then%>
<% end if
rst3.movenext
n=n+1
loop
rst3.close
%>
|
|
| 楼盘排行 |
|
|
|
<%
dim rst5,sqlt5
set rst5=server.createobject("adodb.recordset")
sqlt5="select * FROM comp where icheck=True order by click desc"
'sqlt5=sqlt5 & "and xkz like"&"'%销%中%'"&""
'sqlt4=sqlt4 & "or xkz like"&"'%少量销售%'"&""
'sqlt5=sqlt5 & "order by click desc"
rst5.open sqlt5,conn,1,1
e=1
%>
<%
do while not rst5.eof
%>
|
<%if e mod 4 = 0 then%>
<% end if
rst5.movenext
e=e+1
loop
rst5.close
%>
|
|