| |
|
中文版 |
|
<点击查看大图片>
|
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from goods where 分类='"
select case ltype
case "hanjie":sql=sql&"焊接管"
case "neiluowen":sql=sql&"内螺纹管"
case "lengba":sql=sql&"冷拔管"
case "bowen":sql=sql&"波纹膨胀接管"
case "rejiya":sql=sql&"热挤压管"
case "":sql=sql&"焊接管"
end select
sql=sql&"' order by 浏览数 desc"
rs.open sql,conn,1,1
if not rs.eof then
if rs.recordcount mod 6 =0 then maxpage=rs.recordcount \ 6 else maxpage=rs.recordcount \ 6 + 1
maxpage=cint(maxpage)
for i=1 to rs.recordcount %>
<%
next
end if
%>
| 英文版 |
|
<点击查看大图片> |
| >返回首页< |
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from goods where 分类='"
select case ltype
case "hanjie":sql=sql&"焊接管"
case "neiluowen":sql=sql&"内螺纹管"
case "lengba":sql=sql&"冷拔管"
case "bowen":sql=sql&"波纹膨胀接管"
case "rejiya":sql=sql&"热挤压管"
case "":sql=sql&"焊接管"
end select
sql=sql&"' order by 浏览数 desc"
rs.open sql,conn,1,1
if not rs.eof then
if rs.recordcount mod 6 =0 then maxpage=rs.recordcount \ 6 else maxpage=rs.recordcount \ 6 + 1
maxpage=cint(maxpage)
for i=1 to rs.recordcount %>
<%
next
end if
%>
|
|
