<%
set rs = server.CreateObject("adodb.recordset")
rs.open "select * from tsm_photo order by paixu asc,id desc",conn,1,1
if rs.eof then
else
for i = 1 to rs.recordcount
%>
- " >
" width="960" height="350" >
<%
rs.movenext
next
end if
rs.close
%>
<%
set rs = server.CreateObject("adodb.recordset")
rs.open "select top 4 * from tsm_news1 order by id desc",conn,1,1
if not rs.eof then
for i = 1 to rs.recordcount
%>
- "
href="newsshow.asp?id=<%=rs("id")%>"><%=rs("title")%><%=year(rs("time1"))%>-<%=month(rs("time1"))%>-<%=day(rs("time1"))%>
<%
rs.movenext
next
end if
rs.close
%>
<%
set rs = server.CreateObject("adodb.recordset")
rs.open "select top 4 * from tsm_soft order by id desc",conn,1,1
if not rs.eof then
for i = 1 to rs.recordcount
%>
- "
href="<%=rs("Propics")%>"><%=rs("title")%><%=year(rs("addtime"))%>-<%=month(rs("addtime"))%>-<%=day(rs("addtime"))%>
<%
rs.movenext
next
end if
rs.close
%>
