Question

asp网页调用新闻紧急问题！

<%t=0
set rs=server.createobject("adodb.recordset")
sql="select id,title,content,oColor,oStyle,tuijian,time,firstimagename,infotime,BigClassName,SmallClassName from OYAYA_news where ifshow=1 order by id desc"
rs.open sql,conn,1,1
if not rs.eof then
do while not rs.eof
t=t+1%>........
这段代码是显示网站最新文章，我想只显示某一栏目的最新文章，应该怎么修改？

Answer 1

sql="select top n * from OYAYA_news where ifshow=1 and news_class=X order by id desc"
news_class 数字/整型类型 所属类别

追问

where ifshow=1 and BigClassName(或者 SmallClassName)='xxx'
已经成功调用某一栏目最新文章，现在因为需要，得调用2个栏目的新闻，请又该怎么改？

追答

sql="select * from OYAYA_news where ifshow=1 and news_class=X and news_xclass=XX order by id desc"

Answer 2

where ifshow=1 and BigClassName(或者 SmallClassName)='xxx'