typeid、chanye和touzhi分别是三个下拉表单，keyword是关键字

Set rs= Server.CreateObject ("ADODB.RecordSet")
if typeid<>"b" and chanye<>"a" and touzhi<>"c" and keyword<>"" then
sql = "select * from goods where typeid='"&typeid&"'and touzhi='"&touzhi&"' and chanye='"&chanye&"' and typeid1 like '%"&keyword&"%'"
elseif typeid="b" and chanye="a" and keyword="" and touzhi="c" then
sql = 这里该怎么写？？？？？？？？？？？？？？？？？？？？？
elseif typeid="b" and chanye="a" and keyword<>"" and touzhi="c" then
sql = "select * from goods where typeid1 like '%"&keyword&"%'"
elseif typeid="b" and chanye<>"a" and keyword="" and touzhi="c"then
sql = "select * from goods where chanye='"&chanye&"'"
elseif typeid<>"b" and chanye="a" and keyword="" and touzhi="c"then
sql = "select * from goods where typeid='"&typeid&"'"
elseif typeid="b" and chanye="a" and keyword="" and touzhi<>"c"then
sql = "select * from goods where touzhi='"&touzhi&"'"
elseif typeid<>"b" and chanye<>"a" and keyword="" and touzhi="c"then
sql = "select * from goods where typeid='"&typeid&"'and chanye='"&chanye&"'"
elseif typeid<>"b" and chanye="a" and keyword<>"" and touzhi="c"then
sql = "select * from goods where typeid='"&typeid&"'and typeid1 like '%"&keyword&"%'"
elseif typeid="b" and chanye<>"a" and keyword<>"" and touzhi="c"then
sql = "select * from goods where chanye='"&chanye&"' and typeid1 like '%"&keyword&"%'"
elseif typeid="b" and chanye="a" and keyword<>"" and touzhi<>"c"then
sql = "select * from goods where typeid1 like '%"&keyword&"%' and touzhi='"&touzhi&"'"
elseif typeid<>"b" and chanye="a" and keyword="" and touzhi<>"c"then
sql = "select * from goods where typeid='"&typeid&"'and touzhi='"&touzhi&"'"
elseif typeid="b" and chanye<>"a" and keyword="" and touzhi<>"c"then
sql = "select * from goods where chanye='"&chanye&"'and touzhi='"&touzhi&"'"
elseif typeid<>"b" and chanye<>"a" and keyword="" and touzhi<>"c"then
sql = "select * from goods where typeid='"&typeid&"'and chanye='"&chanye&"' and touzhi='"&touzhi&"'"
elseif typeid="b" and chanye<>"a" and keyword<>"" and touzhi<>"c"then
sql = "select * from goods where chanye='"&chanye&"' and typeid1 like '%"&keyword&"%' and touzhi='"&touzhi&"'"
elseif typeid<>"b" and chanye="a" and keyword<>"" and touzhi<>"c"then
sql = "select * from goods where typeid='"&typeid&"'and typeid1 like '%"&keyword&"%' and touzhi='"&touzhi&"'"
elseif typeid<>"b" and chanye<>"a" and keyword<>"" and touzhi="c"then
sql = "select * from goods where typeid='"&typeid&"'and chanye='"&chanye&"' and typeid1 like '%"&keyword&"%'"
end if

晕。。

这是三个，假如有十个怎么班？？~~~~！！

呵呵，不用看完的，就看这句就行了
elseif typeid="b" and chanye="a" and keyword="" and touzhi="c" then
sql = 这里该怎么写？？？？？？？？？？？？？？？？？？？？？

这里typeid="b" chanye="a" touzhi="c" keyword=""就是不选的意思，

说的好。
我是笨鸟用笨办法，呵呵

那你们平时把三个同级的表单and起来做搜索用什么语句？

我试了。三个表单全选或只选其中一个，没有问题，搜出来的条件都是对的

但要都不选（也就是全部搜索），就出现bug了。

把你思路和元素关系说一下 该改吧

好的，谢谢，说也说不清，我把传到网上你看看。
主要有两大问题，我把源码也传上了，你有空下载帮搞一下。
一、三个表单和关键字都不选时，搜索会出错
二、第一个表单不选，选其他表单，如果结果有两页以上，那么点下页时也会出错，（比如第二个表单的“畜产品加工业”这个就有两页，点下一页就会出错）。

演示页面 www.zh-expo.com/asp4

源文件 www.zh-expo.com/asp4/so.rar

数据库在 www.zh-exp.com/asp4/mhd77/cg988.mdb

<%
dim condition,condition1,condition2,condition3
condition1=request.Form("")
condition2=request.Form("")
condition3=request.Form("")
condition="1=1"
if condition1<>"" then
condition=condition &" and condition1='"&condition1&"'"
end if
if condition2<>"" then
condition=condition &" and condition2='"&condition2&"'"
end if
if condition3<>"" then
condition=condition &" and condition3='"&condition3&"'"
end if
%>
······
<table>
<%
strQuery="select * from menufun where "&condition
set rs=server.createobject("adodb.recordset")
rs.open strQuery,conn,1,1
allnum=rs.RecordCount
for i=1 to allnum
%>
<tr><td><%=rs("funcname")%></td></tr>
<%
rs.movenext
next
%>
</table>