网页在数据库读取按修改时间顺序

来源：百度知道 编辑：UC知道 时间：2024/05/24 01:47:49
请大侠指点，谢谢
我的后台网页是按照ID的顺序来读取，但我想把它改了用修改的时间，网页在数据库读取按修改时间顺序。
以下代码是用ID顺序读取：
<%
dim i,intPage,page,pre,last,filepath
set rs = server.CreateObject("adodb.recordset")
if request("id")="" then
mysql="select * from user order by id desc"
else
mysql="select * from video where subclass="& request("id") &" order by id desc"
end if
rs.PageSize =25
rs.CursorLocation = 3
rs.Open mysql,conn,0,2,1
pre = true
last = true
page = trim(Request.QueryString("page"))
if len(page) = 0 then
intpage = 1
pre = false
else
if cint(page) =< 1 then
intpage = 1
pre = false
else
if cint(page) >= rs.PageCount then
intpage = rs.PageCount
last = false
else
intpage = cint(page)
end if
end if
end if
if not rs.eof t

mysql="select * from user order by id desc"
else
mysql="select * from video where subclass="& request("id") &" order by id desc"
end if
关键在这里

假设你数据库里存储时间的字段为'intime'

应该修改为：
mysql="select * from user order by intime desc"
else
mysql="select * from video where subclass="& request("id") &" order by intime desc"
end if

if request("id")="" then
mysql="select * from user order by id desc"
else
mysql="select * from video where subclass="& request("id") &" order by id desc"
end if

中替换两处，由于你没哟给出时间的标段名，假定为 time 更改
if request("id")="" then
mysql="select * from user order by time desc"
else
mysql="select * from video where subclass="& request("id") &" order by tim