ASP的更改产品展示顺序

来源：百度知道编辑：UC知道时间：2024/06/07 20:00:33

现在要改为后发布的产品和图片排在前面..就是把最新发布的产品排在之前发布的前面
原来的是后发布的产品排在后面的. (源码如下.因版面字数限制.应复到要复的了.请帮看看.修改下)谢谢!

<%
prolenid=Trim(request.querystring("prolenid"))
if prolenid="" then prolenid=0
prolenid2=Trim(request.querystring("prolenid2"))
if prolenid2="" then prolenid2=0

if prolenid=0 then sqloutputs="SELECT books.bookid, books.bookname,books.jg,books.dw, books.bookpic FROM books"
if prolenid<>0 then sqloutputs="SELECT books.bookid, books.bookname,books.jg,books.dw, books.bookpic FROM lm INNER JOIN books ON lm.id = books.rq WHERE lm.id="&prolenid
if prolenid2<>0 then sqloutputs="SELECT books.bookid, books.bookname, books.bookpic FROM lm INNER JOIN books ON lm.id = books.rq1 WHERE lm.id="&prolenid2

set rsoutputs=server.CreateObject("adodb.recordset")

ostr = " order by books.bookid desc"
if prolenid=0 then sqloutputs="SELECT books.bookid, books.bookname,books.jg,books.dw, books.bookpic FROM books" & ostr
if prolenid<>0 then sqloutputs="SELECT books.bookid, books.bookname,books.jg,books.dw, books.bookpic FROM lm INNER JOIN books ON lm.id = books.rq WHERE lm.id="&prolenid & ostr
if prolenid2<>0 then sqloutputs="SELECT books.bookid, books.bookname, books.bookpic FROM lm INNER JOIN books ON lm.id = books.rq1 WHERE lm.id="&prolenid2 & ostr

1楼说的对你得给出数据库的相关信息要不然没法帮你的放补充里吧要是想起来的话回头帮你看看

对呀，要把数据库字段给出来

asp产品展示页面怎样在asp中按一定的顺序展示图片 asp产品展示如何一排可以排多个? 怎么用ASP实现产品展示系统 asp 产品展示显示行列问题谁能提供一个破解版的ASP产品展示系统源代码？问一下ASP中的产品展示功能怎么能变成横排的？谁有像这样的产品展示系统啊? Sony产品展示的网址是?.. 良精网站的产品展示修改