关于复式搜索

[climix]

<form method=post name=form1 action="product/p_search.asp" target="mainFrame">
<table border="1" cellpadding="0" width="100%" bgcolor=#0053b6 bordercolorlight=#0053b6 bordercolordark=#ffffff>

<tr>
<td><img src="search_p.gif">   <font color=#ffffff>产 品 搜 索</font>
</td>
</tr>
</table>
<table border="0" cellpadding="0" width="100%" bgcolor=#0053b6>
<tr><td ><select name=product_style style="BACKGROUND-COLOR: #ffffff; COLOR: #00346b; FONT-FAMILY:宋体; FONT-SIZE: 9pt; border-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-color:#518ac7"><option>请选择商品类别</option>
<option>毛针织</option><option>棉针织</option><option>男装</option><option>少淑装</option><option>淑女装</option><option>妇女装</option><option>老年装</option><option>手钩</option><option>春秋装坯布</option><option>秋冬装坯布</option>
<option>新原料坯布</option><option>裙子</option><option>手套</option><option>围巾</option><option>其他</option>
</select></td></tr>
<tr>
<td><input type="text" name="product_name" value="请输入商品名称" size=20 style="BACKGROUND-COLOR: #ffffff; COLOR: #00346b; FONT-FAMILY:宋体; FONT-SIZE: 9pt; border-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-color:#518ac7">   
<input type="button" name=submit value="搜索" style="BACKGROUND-COLOR: #ffffff; COLOR: #00346b; FONT-FAMILY:宋体; FONT-SIZE: 9pt; border-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-color:#518ac7">
</td>
</tr>

</table>
</form>
接下来,怎么写?

[pizixt]

<option value="毛针织">毛针织</option>
________^ 要加上value

<%
product_style=request("product_style")
product_name=replace(trim(request("product_name")),"'","")
if product_style<>"" and product_name<>"" then
sql="select * from product where product_style='"&product_style&"' and product_name like '%"&product_name&"%'"
....
else
...
end if
%>

[climix]

按了"搜索"怎么没有反应呢?

[787912]

sql="select * from product where product_style='"&request("product_style")&"' and
product_name like '%"&request("product_name")&"%'"