|
|
|
<%rs.open "select * from wslb where bs='0' order by sl asc",conn,1,1
s=1
do while not rs.eof
if s-6=0 then
response.write " "
s=1
end if
%>
"><%=rs("bt")%> |
<%s=s+1
rs.movenext
if rs.eof then exit do
loop
rs.close
%>
|
|
|
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from cpzs where id="&bh,conn,1,1
%>
" width="350"> |
产品名:<%=rs("xh")%>
产品定价:<%=rs("jg")%>
产品型号:<%=rs("bh")%>
袋子尺寸: <%=rs("dsize")%>
箱尺寸: <%=rs("xsize")%> |
<%rs.close
%>
上一款:
<%
sql="select * from cpzs where bs='"&bs&"' and id<"&bh&" order by id desc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if not rs.eof then
%>
"><%=rs("xh")%>
<%
end if
rs.close
%>
| 下一款:
<% sql="select * from cpzs where bs='"&bs&"' and id>"&bh&" order by id asc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if not rs.eof then
%>
"><%=rs("xh")%>
<%end if
rs.close
set rs=nothing
%>
|
|
|
|
|
|