<p><font face="Verdana"><%dim newsid<br/>newsid=Request("showid")</font></p>
<p><font face="Verdana">sql="select top 1 title,id from cnnew where id<"&newsid&" order by id desc" <br/>set rsnews=conn.execute(sql) <br/>if rsnews.eof then <br/>response.write "上一篇文章: 已经是首篇文章了" <br/>else <br/>response.write "上一篇文章: <a href=news-cn.asp?showid="&rsnews("id")&">"&rsnews("title")&"</a>" <br/>end if <br/>response.Write"<p>"<br/>sql="select top 1 title,id from cnnew where id>"&newsid&" order by id" <br/>set rsnews=conn.execute(sql) <br/>if rsnews.eof then <br/>response.write "下一篇文章: 请等待更新" <br/>else <br/>response.write "下一篇文章: <a href=news-cn.asp?showid="&rsnews("id")&">"&rsnews("title")&"</a>" <br/>end if</font></p>
<p>%></p>
<p> </p>
[此贴子已经被作者于2012-8-8 15:23:51编辑过]
页:
[1]