gusucode.com > ASP+ACCESS音乐网站建设设计(源代码+论文+开题报告+答辩PPT+外 > ASP+ACCESS音乐网站建设设计(源代码+论文+开题报告+答辩PPT+外文翻译)\音乐网站设计\news.asp

    <%set rs=server.createobject("adodb.recordset")
sql="select top 8 *  from news order by id desc"
rs.open sql,conn,1,1
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
 <% dim k,l
  l=rs.recordcount
 for k=1 to l %>
<tr><td height="20" style="BORDER-bottom: #999999 1px dotted">
<IMG border=0 src="images/icon.gif">&nbsp;<span style=&quot;font-size:9pt;line-height:15pt"><a href="viewnews.asp?id=<%=rs("id")%>" target="_blank"><%=rs("title")%></a></span>&nbsp; 
</td></tr>
   <% rs.movenext
    next                                                                                                            
  rs.close  %>
</table>