|
|
<%
set rs=server.createobject("adodb.recordset")
str_bigclassname=trim(request.QueryString("bigclassname"))
str_smallclassname=trim(request.QueryString("smallclassname"))
if Trim(Request.QueryString("bigclassname"))<>"" and Trim(Request.QueryString("SmallClassName"))<>"" then
sql="SELECT * from product where bigclassname='"&str_bigclassname&"' and smallclassname='"&str_smallclassname&"' order by ArticleID desc"
elseif trim(request("is_search"))="yes" Then
dim flag,sql
sql="select * from product"
flag=0
key=trim(request("pro_keyword"))
if key="请输入关键词" then
key=""
end if
if key<>"" then
sql=sql&" where title like '%"&key&"%'"
end if
sql=sql&" order by ArticleID desc"
else
sql="select * from product order by ArticleID desc"
end if
rs.open sql,conn,1,3
if rs.eof then
response.write ""
response.end()
end if
if request.QueryString("page_no")="" then
page_no=1
else
page_no=cint(request.QueryString("page_no"))
end if
rs.pagesize=6
rs.absolutepage=page_no
i=rs.pagesize
int_page_count=rs.recordcount\rs.pagesize
if (rs.recordcount mod rs.pagesize)<>0 then
int_page_count=int_page_count+1
end if
record_no=0
jj=0
do while not rs.eof and i>0
record_no=record_no+1
jj=jj+1
i=i-1
%>
|
| LH electric hoist bridge crane |
|
LH electric hoist bridge crane is made up of the rolling crab composed by electric hoist, traveling and trolley ,the three of which are driven together. It has light weight, small volume and simple structure , and it is easy to install, use and maintain the product which is suitable to the work of maintenance, equipment and disassembly. It ranks A5, and we can add the air conditioner and equip with non standard devices such as overload limit switch, remote contol and round rail.
|
|
|
|
|
<%
if (jj mod 3)=0 then '当余数为0,就要换行(即每行3列),这是核心部分.在别处使用时,根据具体列就要修改此处的数。
response.Write ""
end if
rs.movenext
loop %>
|
|
