高手进。帮忙看下一段代码有没有错误

来源:百度知道 编辑:UC知道 时间:2024/06/17 01:46:51
<div class="cr_layout right">
<div class="title2">QQ空间代码</div>
<ul>
<%
set rs22=server.createobject("adodb.recordset")
sql="select classid from FS_NS_Newsclass where id=9 order by id desc"
rs22.open sql,conn,1,1
classid=rs22("classid")
rs22.close
set rs22 = nothing
%><%
set rs2=server.createobject("adodb.recordset")
sql="select top 15 * from FS_NS_News where ClassID='"&classid&"' order by hits desc,id desc"
rs2.open sql,conn,1,1
if rs2.eof and rs2.bof then
response.Write"`Sorry!!`,暂时还没有添加没有记录"
else
%><%do until rs2.eof
%>

<li><span><% =RS2("addtime")%></span><a href="show.asp?id=<% =RS2("id")%>" target="_blank" title="<% =RS2("newstitle"

13行
sql="select top 15 * from FS_NS_News where ClassID='"&classid&"' order by hits desc,id desc"

改为

sql="select top 15 * from FS_NS_News where ClassID='"&classid&"' order by id desc"

可以了么?

粗粗看了一下,应该还是排序的问题