高校问答如果可以散文:从多个文章评论时间里显示其中一个数据
来源：百度文库 编辑：高校问答 时间：2024/05/06 02:40:26
在ASP里，把热评文章按评论时间排序，出现重复文章名的现象，原来是因为有多次评论．我想从多个文章评论时间里只显示其中一个最后评论的那个数据．不知用什么办法？
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 15 shop_books.bookname,shop_books.bookid,shop_books.pingji,shop_pinglun.pinglunid,shop_pinglun.pinglunname,shop_pinglun.pingluntitle,shop_pinglun.pingluncontent,shop_pinglun.pinglundate from shop_pinglun,shop_books where shop_books.bookid=shop_pinglun.bookid order by shop_pinglun.pinglundate desc",conn,1,1
if rs.eof and rs.bof then
response.write "<td align=center><font color=red size=2>对不起，暂无新品！</font></td>"
'response.End
else
%>
<%
没有人知道呀
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 15 shop_books.bookname,shop_books.bookid,shop_books.pingji,shop_pinglun.pinglunid,shop_pinglun.pinglunname,shop_pinglun.pingluntitle,shop_pinglun.pingluncontent,shop_pinglun.pinglundate from shop_pinglun,shop_books where shop_books.bookid=shop_pinglun.bookid order by shop_pinglun.pinglundate desc",conn,1,1
if rs.eof and rs.bof then
response.write "<td align=center><font color=red size=2>对不起，暂无新品！</font></td>"
'response.End
else
%>
<%
没有人知道呀
比较难吖