 |
|
|
|
|
|
|
| |
|
|
|
|
 |
<% set rsTOP=server.createobject("adodb.recordset")
sqlTOP="select top 6 * from news where mytype='热点新闻' order by lls desc"
rsTOP.open sqlTOP,conn,3,3
for i=1 to 10 %>
 |
| <% rsTOP.movenext
if rsTOP.eof then exit for
next
rsTOP.close %> |
 | |
|
| |
|
|
 |
<% set rsnew=server.createobject("adodb.recordset")
sqlnew="select top 6 * from news where mytype='房产新闻' order by id desc"
rsnew.open sqlnew,conn,3,3
for i=1 to 10 %>
 |
| <% rsnew.movenext
if rsnew.eof then exit for
next
rsnew.close %> |
 | |
|
| | |
|
|
 |
<% dim t
Set RsSmall=Server.Createobject("ADODB.Recordset")
RsSmallSrt="select top 14 * from news where mytype='房产知识' order by id desc"
RsSmall.Open RsSmallSrt,Conn,1,3 %>
<% t=0
while not RsSmall.eof %>
|
| <% t=t+1
if t=2 then
t=0 %> <% end if
RsSmall.movenext
wend %> |
 | |
|
| | |
|
| | |
| |
 | |