Question

如何使用sql="select * from aa order by id desc"来显示同上页面上二个不同内容

Answer 1

如何使用sql="select * from aa order by id desc"来显示同上页面上二个不同内容
sql = "select * from main order by id desc" //按id从大到小查询表main
set rs = server.createobject("adodb.recordset")//数据源
rs.open sql,conn,1,1 //打开并查询
if rs.recordcount >0 then //当读取行大于0
rs.pagesize=10 //每页显示10个
total = rs.pagecount //把页码复值给total
if cint(request.querystring("page")) < 1 then //当为首页
page = 1 //定义page为1
else //否则
page = cint(request.querystring("page")) //page为当前页数
end if //结束
if page > total then //判断是否位末页
page = total //
end if
rs.absolutepage = page
i=1
do while not rs.eof and not rs.bof //开始循环读取数据
i=i+1 //定义变量开始提增