Question

asp调用指定分类的文章，怎么修改代码

<%
Set rs = server.CreateObject("adodb.recordset")
sql = "select top 5 * from pf_news order by pf_news_order desc"
rs.Open sql, conn, 1, 1
Do While Not rs.EOF
Set rsc = server.CreateObject("adodb.recordset")
sql = "select * from pf_news_category where id=4"
rsc.Open sql, conn, 1, 1
%>
<li>[<a href="news_category.asp?id=<%=rsc("ID")%>"><%=rsc("pf_news_category_name")%></a>] <a href="news_view.asp?id=<%=rs("ID")%>" title="<%=rs("pf_news_name")%>"><%=left(rs("pf_news_name"),25)%></a></li>
<%
rsc.Close
Set rsc = Nothing
rs.movenext
Loop
rs.Close
Set rs = Nothing
%>我写的这样的，分类调出来了，但是文章没有调出来 调出来还是全部的文章，我想把指定分类的文章调出来

Answer 1

既然是指定分类的文章，那么怎么也得先获取分类，然后在获取文章吧，你的那个逻辑好像反了！

追问

那代码要怎么写吧

Answer 2

pf_news是文章表，pf_news_category 是栏目表吧
如果是那下面这些就不用要了
Set rsc = server.CreateObject("adodb.recordset")
sql = "select * from pf_news_category where id=4"
rsc.Open sql, conn, 1, 1
直接用这个就行了，加个栏目条件
Set rs = server.CreateObject("adodb.recordset")
sql = "select top 5 * from pf_news where 栏目id=4 order by pf_news_order desc"
rs.Open sql, conn, 1, 1
Do While Not rs.EOF
....