您现在的位置: 设计龙 >> 网络编程 >> asp教程 >> 正文

asp相关随机调用文章代码

Author:佚名 Link:本站原创 Hits: Update:2008-8-7 13:35:22
天极网摘 ViVi收藏夹 365Key 和讯网摘 POCO网摘
<%set rs=server.CreateObject("adodb.recordset")
   randomize
   sql="select top 5 * from SW_article where classid in (select classid from SW_article where articleid="&request("articleid")&") order by rnd(-(articleid)*"&rnd()&")"
   rs.open sql,conn,1,1
   do while not rs.eof%>
              <tr>
                <td width="4%">·</td>
                <td width="82%" height="22"><A href="showinfo.asp?articleid=<%=rs("articleid")%>" title="<%=rs("title")%>"><%=rs("title")%></A></td>
                <td width="14%"><%=rs("updatetime")%></td>
              </tr>
     <%rs.movenext
     loop
     rs.close%>
www.sjlong.com发布
   
  • 上一篇文章:
  • 下一篇文章:
  • [回到标题] [回到顶部]