index_article.asp

来自「功能简介: 1) 首页投票调查系统 2）FLASH导航清新直观（带FLA源文件」· ASP 代码 · 共 41 行

<%sub index_article()

sql="select top "&indexarticle&" art_id,cat_id,art_title,art_date,art_count from art order by art_date DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>

<div align="center">
  <center>
<table width="98%" border="0" cellspacing="0" cellpadding="3" height="22" style="border-collapse: collapse" bordercolor="#111111">
  <%do while not rs.eof
sql="select cat_id,cat_name from a_cat where cat_id="&rs("cat_id")
set rscat=server.createobject("adodb.recordset")
rscat.open sql,conn,1,1%><font color="#666666"> </font>
  <tr> 
       <td bgcolor="#FFFFFF" class="chinese" width="96%" height="22"> · <a href="showart.asp?art_id=<%=rs("art_id")%>&cat_id=<%=rs("cat_id")%>" title="<%=rs("art_title")%>,发表于<%=rs("art_date")%>,已经被阅读<%=rs("art_count")%>次。" target="_blank"><%=rs("art_title")%></a><font color="#666666">&nbsp;
    </font><font color="#666666">&nbsp;<span style="font-size: 9pt">[</span></font><span style="font-size: 9pt"><a href="article.asp?cat_id=<%=rscat("cat_id")%>" target="_blank"><font color="#666666"><%=rscat("cat_name")%></font></a></span><font color="#666666"><span style="font-size: 9pt">]</span></td>
  </tr>
  <tr> 
    <td height="1" colspan="2" background="images/dotlineh.gif" bgcolor="#FFFFFF"></td>
  </tr>
  <%
rscat.close
set rscat=nothing
rs.movenext
loop
if rs.eof and rs.bof then
%><font color="#666666"> </font>
  <tr bgcolor="#E7E3E7"> 
    <td class="chinese" colspan="2" bgcolor="#FFFFFF"><font color="#666666">暂时没有文章！</font></td>
  </tr>
  <%end if%><font color="#666666"> </font>
</table>
  </center>
</div>

<%
rs.close
set rs=nothing
end sub
%>