set rs=server.CreateObject("adodb.recordset")
sql="select top 4 * from news where id<>(select top 1 id from news order by id desc) and category=4 order by id desc"
rs.open sql,conn,1,1
response.Write("<div style='padding:20px;line-height:22px;'><li> <a href=""news_view.asp?id="&rs("id")&""">"&left(rs("data"),10)&" "&rs("title")&" </a></li></div>")
sql="select top 4 * from news where id<>(select top 1 id from news order by id desc) and category=4 order by id desc"
rs.open sql,conn,1,1
response.Write("<div style='padding:20px;line-height:22px;'><li> <a href=""news_view.asp?id="&rs("id")&""">"&left(rs("data"),10)&" "&rs("title")&" </a></li></div>")
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货