new1.asp

来自「企业版WAP网站」· ASP 代码 · 共 26 行

<% 
        set rs = server.createobject("adodb.recordset")
	sql="select top 3 * from article order by dateandtime desc" 
	rs.open sql,conn,1,1
if rs.eof and rs.bof then
    response.write "&#x6CA1;&#x6709;&#x4EFB;&#x4F55;&#x6587;&#x7AE0;<br/>"
else
	dim i 
	   	i=1 
	do while not rs.eof and i<=mypagesize 
        if rs("articleon")=0 then
	        response.write "<a href='list.asp?id="&rs("articleid")&"'>"&((page-1)*10+i)&"."&untow(rs("title"))&"</a><br/> "
        end if
        if rs("articleon")=1 then
            response.write "<a href='lianjie.asp?id="&rs("articleid")&"'>"&((page-1)*10+i)&"."&untow(rs("title"))&"</a><br/>"
        end if
        if rs("articleon")=2 then
            response.write "<a href='softdown.asp?id="&rs("articleid")&"&amp;aid="&rs("classid")&"&amp;bid="&rs("Nclassid")&"'>"&((page-1)*10+i)&"."&c2u(rs("title"))&"</a><br/>"
        end if
%>
<%
    i=i+1
    rs.movenext
    loop
end if
%>