最新日志
最新回复
我的相册
站点统计
2008-4-27 10:37:00
>>上一页,下一页链接
exec="Select top 1 id,topic,content from photo where 分类="" and  ID<"&id&" order by id desc"
set rs=server.reateobject("adodb.recordset")
rs.open exec,conn,1,1

if rs.Recordcount>0 then
Response.write "<a href="/blog/?id="&rs("id")&"'>[" & rs("topic") & "]</a>"
else
Response.write "没有了"
End if

rs.close
set rs=nothing



exec="Select top 1 id,topic,content from photo where 分类="" and  ID>"&id&" order by id asc"
set rs=server.reateobject("adodb.recordset")
rs.open exec,conn,1,1

if rs.Recordcount>0 then
Response.write "<a href="/blog/?id="&rs("id")&"'>[" & rs("topic") & "]</a>"
else
Response.write "没有了"
End if

rs.close
set rs=nothing
Kering | 阅读全文 | 回复(0) | 引用通告 | 编辑
发表评论:
生活因感动而精彩,理想在创造中放飞                        http://www.52qj.com/blog/user1/2/index.html
Powered by Oblog.