<%
set rs=server.createobject("adodb.recordset")
sqlt = "select top 2 * from db_student_q where txt='anli' order by id desc"
rs.open sqlt,conn,1,1
do while not rs.eof
%>
<%
rs.movenext
loop
%>
"><%=rs("username")%>
<%=left(htmlstr(rs("content")),55)%>...
<%=left(htmlstr(rs("content")),55)%>...
<%
set rst=server.createobject("adodb.recordset")
sqlt = "select top 5 * from db_student_q where txt='news' order by id desc"
rst.open sqlt,conn,1,1
do while not rst.eof
%>
<%
rst.movenext
loop
%>
<%=left(rst("about"),55)%>...
<%
sql = "select top 8 id,pic,schoolid from db_kehu_pic_q "
sql = sql & " order by edittime desc,id desc "
set rsc = Server.CreateObject("ADODB.RecordSet")
rsc.Open sql,conn,1,1
while not rsc.eof
%>
<%
rsc.movenext
wend
rsc.close
set rsc=nothing
%>