产品分类 |
|
<%set rs=server.createobject("adodb.recordset")
sql="select * from SMT_ypxxtwo where SMT_ypxxone_id="&request("id")&" order by SMT_date desc"
rs.open sql,conn,1,1%>
<%n=0
do while not rs.eof
n=n+1
set rs1=server.createobject("adodb.recordset")
sql1="select * from SMT_cp where SMT_key=1 and SMT_key1=1 and SMT_key2=1 and SMT_ypxxtwo_id="&rs("SMT_ypxxtwo_id")
rs1.open sql1,conn,1,1
twocount=rs1.recordcount
rs1.close%>
><%=rs("SMT_ypxxtwo")%> (<%=twocount%>)
|
<%if n mod 3=0 then response.write(" ")
rs.movenext
loop%>
<%rs.close%>
|
|