一个上下翻页的设置
就是这些代码可是怎么调下面的上一篇下一篇就是不能正常老是显示上一篇己经没有下一篇己经没有的问题
<!--#include file="top.asp"-->
<!--#include file="conn.asp"-->
<%set rs1=server.CreateObject("adodb.recordset")
sql1="select * from news where id="&request("id")
rs1.open sql1,conn,1,1
classid=rs1("classid")
select case classid
case "2"
classname="公司动态"
case "3"
classname="公司动态"
case "4"
classname="公司动态"
case "5"
classname="公司动态"
case "6"
classname="公司动态"
case "7"
classname="公司动态"
case "8"
classname="公司动态"
case "9"
classname="公司动态"
case "10"
classname="公司动态"
case "11"
classname="公司动态"
case "12"
classname="公司动态"
case "13"
classname="公司动态"
case "14"
classname="公司动态"
case "15"
classname="公司动态"
end select%>
<center>
<div align="center" id="marqueediv1"></div>
</center>
<script>
new Marquee("marqueediv1",0,15,760,52,40,5000,10000)
</script>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="5"></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="8"> </td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="5"> </td>
<td width="190" valign="top"><table width="190" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3"><img name="sjkb_r2_c2" src="../newimage/sjkb_r2_c2.gif" width="190" height="44" border="0" id="sjkb_r2_c2" alt="" /></td>
</tr>
<tr>
<td width="5" rowspan="3" background="../newimage/sjkb_r6_c2.gif"> </td>
<td width="180" align="center"><img name="sjkb_r6_c4" width="170" height="100" border="0" id="sjkb_r6_c4" alt="" /></td>
<td width="5" rowspan="3" background="../newimage/sjkb_r6_c9.gif"> </td>
</tr>
<tr>
<td height="8"> </td>
</tr>
<tr>
<td height="3"> </td>
</tr>
<tr>
<td colspan="3"><img name="sjkb_r13_c2" src="../newimage/sjkb_r13_c2.gif" width="190" height="13" border="0" id="sjkb_r13_c2" alt="" /></td>
</tr>
</table>
<table width="190" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8"> </td>
</tr>
</table>
<table width="190" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8" align="center"><table width="188" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3"><img name="sq_r46_c2" src="../newimage/sq_r46_c2.gif" width="188" height="37" border="0" id="sq_r46_c2" alt="" /></td>
</tr>
<tr>
<td width="6" background="../newimage/sq_r48_c2.gif"> </td>
<td width="176" align="center"><table width="160" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5" rowspan="9"> </td>
<td> </td>
<td width="5" rowspan="9"> </td>
<td> </td>
<td width="5" rowspan="9"> </td>
</tr>
<tr>
<td> <a target="_blank" href="viewcompany.asp@id=778"> </a><img name="idnex_r15_c40" width="80" height="30" border="0" id="idnex_r15_c40" alt="" /></td>
<td> <a target="_blank" href="viewcompany.asp@id=200"> </a><img name="idnex_r15_c40" width="80" height="30" border="0" id="idnex_r15_c40" alt="" /></td>
</tr>
<tr>
<td height="5"> </td>
<td> </td>
</tr>
<tr>
<td> <img name="idnex_r15_c40" width="80" height="30" border="0" id="idnex_r15_c40" alt="" /></td> <td> <img width="80" height="30" border="1" style="border-color:#CCCCCC" alt="" /></td>
</tr>
<tr>
<td height="5"> </td>
<td> </td>
</tr>
<tr>
<td> <img name="idnex_r31_c33" width="80" height="30" border="0" id="idnex_r31_c33" alt="" /></td> <td> <img name="idnex_r23_c32" width="80" height="30" border="0" id="idnex_r23_c32" alt="" /></td>
</tr>
<tr>
<td height="5"> </td>
<td> </td>
</tr>
<tr>
<td> <img name="idnex_r6_c39" width="80" height="26" border="0" id="idnex_r6_c39" alt="" /></td> <td> <img name="idnex_r23_c40" width="80" height="30" border="0" id="idnex_r23_c40" alt="" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table></td>
<td width="6" background="../newimage/sq_r48_c9.gif"> </td>
</tr>
<tr>
<td colspan="3"><img name="sq_r58_c2" src="../newimage/sq_r58_c2.gif" width="188" height="13" border="0" id="sq_r58_c2" alt="" /></td>
</tr>
</table></td>
</tr>
</table>
</td>
<td width="5"> </td>
<td width="554" align="center" valign="top"><table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="22" class="waikuangsj1">
<%if classid="20" then%>
<%else%>
</td>
<td width="24" valign="middle" class="waikuangsj1"><img name="sjkbxx_r2_c7" src="../newimage/sjkbxx_r2_c7.gif" width="17" height="18" border="0" id="sjkbxx_r2_c7" alt="" /></td>
<td width="494" align="left" class="waikuangsj1">当前位置：<%=classname%>>><%=rs1("title")%></td>
</tr>
</table>
<table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"></td>
</tr>
</table>
<table width="540" border="0" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC" >
<tr>
<td bgcolor="#f9f9f9" class="waikuangsj2"><table width="540" height="40" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="15"> </td>
<td width="22" align="left"><img name="sjkbxx_r4_c6" src="../newimage/sjkbxx_r4_c6.gif" width="7" height="7" border="0" id="sjkbxx_r4_c6" alt="" /></td>
<td width="432" align="left" class="font2" style="font-size:15px;font-weight:bold"><span class="title"><%=rs1("title")%></span><span class="font1 style1"> </span></td>
<td width="69" align="left" class="font2"></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top" class="waikuangsj3">
<table width="72%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="7" height="395"> </td>
<td width="25"><img src="images/spacer.gif" width="25" height="1" /></td>
<td width="551" valign="top">
<table width="500" height="377" border="0" align="center">
<tr>
<td width="494" class="font1"><hr /></td>
</tr>
<tr>
<td>
<span class="font1 style1"> </span>
<div align="center">
<%if rs1("img") <> "" then
%>
<img src="admin/<%=rs1("img")%>" width="400" height="300" />
<%end if%>
</div></td>
</tr>
<tr>
<td height="20" valign="top" class="font1"> <%=rs1("content")%></td>
</tr>
</table>
<%end if%>
</td>
</tr>
</table></td>
</tr>
</table>
<table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8"> </td>
</tr>
<tr>
<td bgcolor="#F9F9F9" class="waikuangsj2"><table width="538" height="20" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="398" class="font2"><div align="right">作者： 来源：
浏览次数： <span class="font1 style1">上传日期:<%=rs1("date")%></span></div></td>
<td width="40"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="8"> </td>
</tr>
</table>
<table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="waikuangsj2"><table width="538" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20"> </td>
<td width="518" align="left" class="font2"><%
sql = "Select id,title from news where id = "& id-1
Set Rs = conn.execute(sql)
if Rs.eof and Rs.bof then
Response.write "上一篇：已经没有了。"
else
Response.write "上一篇：<a href=view.asp?id="& rs(0) &">"& Qcdn.HTMLcode(rs(1)) &"</a>"
end if%>
</td>
</tr>
<tr>
<td> </td>
<td align="left" class="font2"><% rs.close
sql = "Select id,title from news where id = "& id+1
Set Rs = conn.execute(sql)
if Rs.eof and Rs.bof then
Response.write "下一篇：已经没有了。"
else
Response.write "下一篇：<a href=view.asp?id="& rs(0) &">"& Qcdn.HTMLcode(rs(1)) &"</a>"
end if
rs.close
%> </td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8"> </td>
</tr>
<tr>
<td><img width="540" height="100" border="0" /></td>
</tr>
<tr>
<td height="8"> </td>
</tr>
</table></td>
<td width="6"> </td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="10"> </td>
</tr>
</table>
<!--#include file="bottom.asp"-->
