UC知道asp 二级分类添加
来源：百度知道 编辑：UC知道 时间：2024/05/14 17:21:04
lb 一级分类 lb1 二级分类
把lb1添加进去，让他读取出来
比如 www.xxx.com/pro_list.asp?lb=一级产品名字?lb1=二级产品名字
<%lb=request.QueryString("lb")%>
<%lb1=request.QueryString("lb1")%>
<%set rs=server.createobject("adodb.recordset")
url="pro_list.asp?"
if lb<>"" then
sql="select * from products where lb='"&lb&"' order by postTime desc "
else
sql="select * from products order by postTime desc"
end if
rs.open sql,conn,1,3
lb=request.QueryString("lb")
hangnum="12"
rs.pagesize=int(hangnum)
Page=REQUEST("Page")
yeshu=INT(rs.RECORDCOUNT/hangnum*-1)*-1
textnum=rs.pagesize
<
把lb1添加进去，让他读取出来
比如 www.xxx.com/pro_list.asp?lb=一级产品名字?lb1=二级产品名字
<%lb=request.QueryString("lb")%>
<%lb1=request.QueryString("lb1")%>
<%set rs=server.createobject("adodb.recordset")
url="pro_list.asp?"
if lb<>"" then
sql="select * from products where lb='"&lb&"' order by postTime desc "
else
sql="select * from products order by postTime desc"
end if
rs.open sql,conn,1,3
lb=request.QueryString("lb")
hangnum="12"
rs.pagesize=int(hangnum)
Page=REQUEST("Page")
yeshu=INT(rs.RECORDCOUNT/hangnum*-1)*-1
textnum=rs.pagesize
<
<%
Dim Rs,sql
Set rs = Server.CreateObject("adodb.recordset")
if lb<>"" then
if lb1<>"" then
if lb2<>"" then
sql="select * from products where lb='"&lb&"' and lb1='"&lb1&"' and lb2='"&lb1&"' order by postTime desc "
else
sql="select * from products where lb='"&lb&"' and lb1='"&lb1&"' order by postTime desc "
end if
else
sql="select * from products where lb='"&lb&"' order by postTime desc "
end if
end if
rs.open sql,conn,1,1
%>
怎么没说出现什么问题啊？
违反规则是个坏的选择
一级是父级 三级是子集
不能又当老爸又当儿子的儿子