| <%set rs=server.createobject("adodb.recordset")
rs.open "select top 6 id,title,adddate from news where bigclassname in (select bigclassname from bigclass_new where bigclassid=1) and smallclassname in (select smallclassname from smallclass_new where smallclassid=2) order by id desc",conn,1,1
if not rs.eof then
i=1
do while not rs.eof and i<7%>
<%rs.movenext
i=i+1
loop
end if
rs.close
set rs=nothing%> |
| <%set rs=server.createobject("adodb.recordset")
rs.open "select top 6 id,title,adddate from news where bigclassname in (select bigclassname from bigclass_new where bigclassid=1) and smallclassname in (select smallclassname from smallclass_new where smallclassid=9) order by id desc",conn,1,1
if not rs.eof then
i=1
do while not rs.eof and i<7%>
<%rs.movenext
i=i+1
loop
end if
rs.close
set rs=nothing%> |
