|
<%
sql="select * from miscell_class where basclass='"+basclass+"' and flag='0' order by sortnum"
rs.open sql,cn,1,1
do while not rs.EOF
if classcode="" then classcode=trim(rs("classcode"))
url=myurl+"&classcode="+trim(rs("classcode"))
%>
<%
rs.MoveNext
loop
rs.Close
%>
|
|
<%
sql="select keyno,classcode,title,updatetime,website,creadate from miscell where classcode='"+classcode+"' and state='1' order by sortnum desc"
rs.Open sql,cn,1,1
i=1
pagesize=20
rs.PageSize=pagesize
if pageno="" then pageno=1 else pageno=cint(pageno)
if rs.PageCount>0 then rs.AbsolutePage=pageno
pagecount=rs.PageCount
reccount=rs.RecordCount
do while not rs.EOF and i<=pagesize
%>
|
| ·<%=trim(rs("title"))%> <%=rs("updatetime")%> |
<%
i=i+1
rs.MoveNext
loop
rs.Close
%>
| |
|
共有 <%=reccount%> 条新闻
<%if pagecount>1 then%>
分页:
<%if pageno>1 then%>
<<上页
<%end if%>
<%for j=1 to pagecount
if j=pageno then color2="ff0000" else color2="000000"
%>
><%=j%>
<%next%>
页
<%if pageno
下页>>
<%end if%>
<%end if%>
|
|
|