產品特點：<%=Cutstr(DelHTML(trim(rs("content"))),48) %>
零投訴我承諾——3.15"零投訴"產品展示區(qū)
-
<%
dim inum,wherelist,sql,z
inum=0
set rs=server.CreateObject("adodb.recordset")
z=GetSqlSafeStr(trim(request("z")))
brandname = GetSqlSafeStr(trim(request("brandname")))
wherelist = " a.logo<>''"
if z<>"" then
wherelist = wherelist & " and zimu='"&z&"'"
end if
if brandname <> "" then
wherelist = wherelist & " and pinpai like '%"&brandname&"%'"
end if
sql = "select Title,Cid,a.logo,a.content,type,zimu,pinpai,zhanneizhan from Product as a inner join company as b on a.Cid=b.id where "&wherelist&" order by a.orderid desc,a.id desc"
rs.open sql,conn,1,1
do while(not rs.eof)
%>
- <% rs.MoveNext() loop rs.close %>
誠信宣言參與企業(yè)
-
<%
set rs=server.CreateObject("adodb.recordset")
wherelist = " status=1 and isfaith=1"
sql="select * from company where "&wherelist&" order by orderid desc,id desc"
rs.open sql,conn,1,1
do while(not rs.eof)
%>
- " title="<%=rs("pinpai") %>" target="_blank">
.jpg" alt="<%=rs("pinpai") %>">
<%
rs.MoveNext()
loop
rs.close
ConnClose()
%>