日期:2014-05-17 浏览次数:21053 次
<div id="demo">
<div id="demo1">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="middle"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<%
set rs=server.CreateObject("ADODB.recordset")
sql="select * from product where index='1' order by id desc"
'sql="select * from product order by id desc"
rs.open sql,conn,1,3
if rs.eof then
%>
<!--<script language="JavaScript" type="text/javascript"> alert('暂无产品信息!');history.go(-1)</script>-->
<%
response.Write"暂无相关信息"
response.end
end if
a=cint(rs.recordcount)
mypage=request.querystring("whichpage")
if mypage="" then
mypage=1
end if
mypagesize=request.querystring("pagesize")
if mypagesize="" then
mypagesize=8
end if
rs.movefirst
rs.pagesize=mypagesize
maxcount=cint(rs.pagecount)
rs.absolutepage=mypage
howmany=0
a=1
%> <tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td></td>
</tr>
<tr>
<%do while not rs.eof and howmany<mypagesize%>
<td height="75">
<table width="75" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="31%" height="61"><table width="110" border="0" cellpadding="2" cellspacing="3">
<tr>
<td width="110" height="16" align="center" valign="middle"><a href="productxx.asp?id=<%=rs("id")%>" title="<%=rs("title")%>" class="aa"><img src="<%=rs("pic")%>" border="0" width="155" height="127"></a></td>
</tr>
<tr>
<td height="16" align="center"><div style="margin-top:5px;"><a href="productxx.asp?id=<%=rs("id")%>" title="<%=rs("title")%>"><%=left(rs("title"),10)%></a></div></td>
</tr>
</table></td>
</tr>
</table>
</td>
<%if a mod 4=0 then%>
</tr>
<%end if%>
<%
a=a+1
howmany=howmany+1
rs.movenext
loop
%>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" valign="middle"></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td align="center"></td>
</tr>
<tr>
<td align="right"></td>
</tr>
</table></div>
<div id="demo2"></div>