new.asp

该程序是初学者最好用的程序!~欢迎大家使用 QQ:68056085

<% @LANGUAGE="VBSCRIPT" CODEPAGE="65001" %>
<!--#include file="conn.asp"-->
<!--#include file="char.asp"-->
<% 
        set rs = server.createobject("adodb.recordset")
	sql="select top 80 * 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
If Request.QueryString("Page") = "" or Request.QueryString("Page") <= 0 then	
Page = 1
Else
Page = CINT(Request.QueryString("Page"))
End If
rs.pagesize =10
total  = rs.RecordCount
rs.absolutepage=page
mypagesize = rs.pagesize
	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
%>