<%
sql="select * from [info] where wz='蛋糕' order by [jg] desc"
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.open sql,conn,1,1
if request("page")="" then
page=1
else
page=clng(request("page"))
end if
m=0
dim t
rs.pagesize=40
if page
if page>rs.pagecount then page=rs.pagecount
if rs.pagecount>0 then rs.absolutepage=page
DO WHILE NOT RS.EOF and m
%>
想實現按價格從底往高的排列,這個好象沒有作用。
sql="select * from [info] where wz='蛋糕' order by [jg] desc"
從低到高,去掉desc,desc是從高到低
sql="select * from [info] where wz='蛋糕' order by [jg] "