简单查询问题?
第一页:
<form name= "form1 " method= "post " action= "search3.asp ">
<td width= "92 ">
<select name= "k1 ">
<option value= " "> 所有菜系 </option>
<option value= "川菜 "> 川菜 </option>
<option value= "小吃 "> 小吃 </option>
<option value= "火锅 "> 火锅 </option>
<option value= "粤菜 "> 粤菜 </option>
</select>
</td>
<td width= "106 "> <select name= "k2 ">
<option value= " "> 所有地区 </option>
<option value= "一环内 "> 一环内 </option>
<option value= "一环到二环 "> 一环到二环 </option>
<option value= "二环到三环 "> 二环到三环 </option>
<option value= "三环外 "> 三环外 </option>
</select> </td>
<td width= "81 "> <select name= "k3 ">
<option value= " "> 所有地区 </option>
<option value= "金牛 "> 金牛区 </option>
<option value= "锦江 "> 锦江区 </option>
<option value= "青羊 "> 青羊区 </option>
<option value= "武侯 "> 武侯区 </option>
<option value= "成华 "> 成华区 </option>
<option value= "其他 "> 其他 </option>
</select> </td>
<td width= "56 ">
<input type= "submit " name= "Submit " value= "搜索 " />
</td>
</form>
第二页:
<%
dim kk1
kk1=request( "k1 ")
dim kk2
kk2=request( "k2 ")
dim kk3
kk3=request( "k3 ")
dim cxsql
cxsql= "SELECT * FROM shoppp_s12 WHERE shop_cx= 'kk1 ' and shop_huan= '