触摸屏租赁
Touch screen rental
广告机租赁
Advertising rental
机器人租赁
Robot leasing
 当前位置:首页 > 全部 > 数据库显示翻页

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

<title>XXX</title><meta  Name="keywords" content="XXX">

<meta  Name="description"  content="XXX">

<link href="../../images/ay_leven.css" rel="stylesheet" type="text/css" />

</head>

<!--#include file="conn.asp"-->

<body>

<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" class="content">

<tr>

<td background="../../images/hori_line1.gif" width="1"></td>

<td valign="top"> 

<table width="93%" border="0" align="center" bordercolorlight="white" class="content">

<tr>

<%

Dim perpage

perpage=6

dim page,moveto

page=request.querystring("page")

if page="" or not isnumeric(page) then

page=1

end if

moveto=perpage*(page-1)

set rs=server.CreateObject("ADODB.RecordSet")

sql="select * from products  order by orders asc,createdate desc"

rs.open sql,conn,1,1

if not rs.eof then rs.move moveto

for j=1 to perpage

if rs.eof then exit for

%>

<td valign="top" align="center">

<table width="228" border="0" cellspacing="0" cellpadding="0" >

<tr>

<td width="46%" align="center" valign="middle"  class="b2"><a href="product.asp?ID=<%=rs("ProductId")%>"><img src="<%= rs("small_pic") %>" width="64" height="64" border="0" /></a></td>

<td width="54%" align="left" valign="middle"><p class="s1">工程编号:<%=rs("Productid")%></p>

<p class="s1">工程名称:<a href="product.asp?ID=<%=rs("ProductId")%>"><font  color="#000000"><%=rs("ProductName")%></font></a></p></td>

    </tr>

  </table></td>

<%

rs.movenext

if j mod 2=0 then response.write "</tr><tr>"

next

%>

</tr>

<tr>

<td colspan="3" align="center">

<%

if page>1 then

response.write "<a href=" & request.servervariables("SCRIPT_NAME") & "?ID=" & qs & "&Style=" & name & "&page=" & page-1 & ">上一页" & "</a>"

else

response.write "上一页"

end if

%>

&nbsp;

<%

if not rs.eof then

response.write "<a href=" & request.servervariables("SCRIPT_NAME") & "?ID=" & qs & "&Style=" & name & "&page=" & page+1 & ">下一页</a>"

else

response.write "下一页"

end if

%>

</td>

</tr>

<%rs.close%>

</table>

<table width="93%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td><hr size="1" /></td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>


工作室地址:重庆石桥铺电脑城B座 | 微信:z35544216 | 网址:www.35544216.com