|
|
<%
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
%>
|
ZD1Conical rotor motor(0.8~13W)
ZDY1Conical rotor motor(0.2~0.8K) |
|
|
| |
|
|
|
|
<%
if (jj mod 3)=0 then '当余数为0,就要换行(即每行3列),这是核心部分.在别处使用时,根据具体列就要修改此处的数。
response.Write ""
end if
rs.movenext
loop %>
|
|
