<!-- #include file="conn.asp"-->
<%
set rs=server.CreateObject("adodb.recordset")
if request("selectkey")="" then '假设你的搜索框名为"selectkey"
sql="select * from 数据表名"
else
sql="select * from 数据表名 where BigClass like '%"&trim(request("selectkey"))&"%' or BigClass_New like '%"&trim(request("selectkey"))&"%' or newsClass like '%"&trim(request("selectkey"))&"%' or product like '%"&trim(request("selectkey"))&"%' or SmallClass like '%"&trim(request("selectkey"))&"%'"
end if
rs.open.sql,conn,1,1
%>
祝好运!
温馨提示:答案为网友推荐,仅供参考