<%
set rst=server.createobject("adodb.recordset")
'sqlstr="select top 7 * from tc where del2=1 order by addtime desc"
sqlstr="select top 7 * FROM t_news WHERE n_tid =52 ORDER BY n_id DESC"
rst.open sqlstr,conn,3,3
%>
<% if rst.eof or rst.bof then
response.write("没有最新消息!")
else %>
<%
for i=1 to 7
if not rst.eof and not rst.bof then %>
· /<%=(rst.Fields.Item("n_fname").Value)%>" target="_blank"><%response.write strvalue(trim(rst("n_title")),34)%>
<% else
exit for
end if
rst.movenext
'i=i+1
next
end if
rst.close
set rst=nothing
%>
<%
set rst=server.createobject("adodb.recordset")
sqlstr="select top 8 * from st where del=1 order by addtime desc"
rst.open sqlstr,conn,3,3
%>
<% if rst.eof or rst.bof then
response.write("没有最新消息!")
else %>
<%
for i=1 to 8
if not rst.eof and not rst.bof then %>
<% else
exit for
end if
rst.movenext
'i=i+1
next
end if
rst.close
set rst=nothing
%>
最新老师信息
老师姓名
身份
家教科目
所在学校
专业
<%
set rst=server.createobject("adodb.recordset")
sqlstr="select top 8 * from tc where del=1 order by addtime desc"
rst.open sqlstr,conn,3,3
%>
<% if rst.eof or rst.bof then
response.write("没有最新消息!")
else %>
<%
for i=1 to 8
if not rst.eof and not rst.bof then %>
<%
set rst=server.createobject("adodb.recordset")
sqlstr="select top 3 * from tc where del2=1 order by addtime desc"
rst.open sqlstr,conn,3,3
%>
<% if rst.eof or rst.bof then
response.write("没有最新消息!")
else %>
<%
for i=1 to 3
if not rst.eof and not rst.bof then %>
<%
set rst=server.createobject("adodb.recordset")
'sqlstr="select top 7 * from tc where del2=1 order by addtime desc"
sqlstr="select top 7 * FROM t_news WHERE n_tid =49 ORDER BY n_id DESC"
rst.open sqlstr,conn,3,3
%>
<% if rst.eof or rst.bof then
response.write("没有最新消息!")
else %>
<%
for i=1 to 7
if not rst.eof and not rst.bof then %>
· /<%=(rst.Fields.Item("n_fname").Value)%>" target="_blank"><%response.write strvalue(trim(rst("n_title")),34)%>
<% else
exit for
end if
rst.movenext
'i=i+1
next
end if
rst.close
set rst=nothing
%>
<%
set rst=server.createobject("adodb.recordset")
'sqlstr="select top 7 * from tc where del2=1 order by addtime desc"
sqlstr="select top 7 * FROM t_news WHERE n_tid =50 ORDER BY n_id DESC"
rst.open sqlstr,conn,3,3
%>
<% if rst.eof or rst.bof then
response.write("没有最新消息!")
else %>
<%
for i=1 to 7
if not rst.eof and not rst.bof then %>
· /<%=(rst.Fields.Item("n_fname").Value)%>" target="_blank"><%response.write strvalue(trim(rst("n_title")),34)%>
<% else
exit for
end if
rst.movenext
'i=i+1
next
end if
rst.close
set rst=nothing
%>
<%
set rst=server.createobject("adodb.recordset")
'sqlstr="select top 7 * from tc where del2=1 order by addtime desc"
sqlstr="select top 7 * FROM t_news WHERE n_tid =51 ORDER BY n_id DESC"
rst.open sqlstr,conn,3,3
%>
<% if rst.eof or rst.bof then
response.write("没有最新消息!")
else %>
<%
for i=1 to 7
if not rst.eof and not rst.bof then %>
· /<%=(rst.Fields.Item("n_fname").Value)%>" target="_blank"><%response.write strvalue(trim(rst("n_title")),34)%>
<% else
exit for
end if
rst.movenext
'i=i+1
next
end if
rst.close
set rst=nothing
%>