Question

ASP排序 问题

以下代码是一个留言系统，但是排序要按照ID顺序排序，数据库的ID，哪个好心人可以帮一下忙！
<%sql="select * from Pro_Ly where Pro_id="&pro_id
oRs.open sql,oConn,1,1

%>

<%while not oRs.eof%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="right104">
<tr>
<td>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>
<td class="right105">讨论者：<span class="right106"><%if oRs("username")<>"" then%><a href="index.asp?user_name=<%=oRs("username")%>"><%=oRs("username")%></a><%else%>游客<%end if%></span></td>
</tr>
<tr>
<td class="right107"><%=oRs("Ly_content")%></td>
</tr>
<tr>
<td align="right" class="right108">发表时间：<%=oRs("Ly_time")%></td>
</tr>
</table></td>
</tr>
</table>
<%oRs.movenext
wend
oRs.close()
%>

Answer 1

sql="select * from Pro_Ly where Pro_id="&pro_id&" Order by ID Desc"

Answer 2

sql="select * from Pro_Ly where Pro_id="&pro_id&" order by id desc"

Answer 3

sql="select * from Pro_Ly where Pro_id="&pro_id& "order by id desc"