Question

高手帮忙改下分页代码

<table bgcolor="#000000" border="0" cellspacing="1" align="center" cellpadding="0">
<tr bgcolor="#FFFFFF">
<td valign="top">
<table bgcolor="#000000" border="0" cellspacing="1" align="center" cellpadding="0">
<tr bgcolor="#FFFFFF" >
<td width="50" align="center" height="40"><font color="#FF0000">序号</font></td>
<td width="250" align="center"><font color="#FF0000">产品名称</font></td>
<td width="130" align="center"><font color="#FF0000">产品型号</font></td>
<td width="50" align="center"><font color="#FF0000">单位</font></td>
<td width="53" align="center"><font color="#FF0000">价格</font></td>
<td width="30" align="center"><font color="#FF0000">查看</font></td>
</tr>
<%
set rst=server.CreateObject("adodb.recordset")
sql="select * from [sme_proinfo] where pro_class='"&request("id")&"'"
rst.open sql,conn,1,1
if rst.eof and rst.bof then
response.write "暂时没有信息！"
else
do while not rst.eof%>
<tr bgcolor="#FFFFFF">
<td width="50" align="center" height="40"><%=rst("pro_id")%></td>
<td width="250" align="center"><%=rst("pro_title")%></td>
<td width="130" align="center"><%=rst("pro_type")%></td>
<td width="50" align="center"><%=rst("dw")%></font></td>
<td width="53" align="center"><%=rst("sme_langstate")%></font></td>
<td width="30" align="center"><a href="proshow.asp?id=<%=rst("pro_id")%>" target="_blank">详情
</a></font></td>
</tr>
<%rst.movenext
loop
rst.close
end if%>
</table>
</td>
</tr>
</table>
想做成每页20个记录，有数字分页，然后pro_id最好能是自动编号
高手帮忙解决下，拜托啦

Answer 1

我懒得帖了，给你地址，我做的杂记，几种分页方式

http://bbs.kulilac.com/viewthread.php?tid=964&extra=page%3D1