这是提取前6条数据的代码,如何把它改为提取从前面第3条开始以后的6条数据,也就是第3到第9条数据.急等高人指点!
sql="select top 6 id,topic from news where hidden=1and c_id=1 order by id desc"
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
id=rs("id")
topic=rs("topic")
response.write vbcrlf&"
[tr][td] [本地] "&joekoe_cms.code_html(topic,1,16)&"[/td][/tr]"
rs.movenext
loop
rs.close