newslist.asp

以前企业建网站

<% i=0 %> 
<%
sql="select top 10 * from news order by news_id desc"
rs.open sql,conn,3,3
%>
<table cellspacing="0" cellpadding="2" weight=140><tr><td colspan="2">公司动态: <font color="#FF0000">
	NEWS</font></td></tr>     
<% do while not rs.eof and i<=10 %> 
<tr><td width="11" valign="top"><img border="0" src="images/001.gif" width="11" height="10"></td><td><a href="newsweb.asp?idd=<%=rs("news_id")%>" target="_blank"><%=rs("news_title")%></a></td></tr> 
<% 
i=i+1         
rs.movenext        
loop          
rs.close 
%> 
<tr><td align="right" colspan="2"><a href="newsall.asp"> 
更多&gt;&gt;&gt;</a></td></tr></table>