prod_search.asp

网上购物系统

<!--#include file=Conn.asp -->
<!--#include file=include/MyRequest.asp -->
<!--#include file=Sub.asp-->
<!--#include file=include/Pages.asp-->
<%
Call Header("商品搜索","商品搜索")
response.write 	"<div class=MainDesc>"&_
				"	<table width=100% border=0>"&_
				"		<form name=form1 action=prod_ListSearch.asp method=get>"&_
				"		<tr>"&_
				"			<td valign=top>商品类别:</td>"&_
				"			<td><select name=cid size=5>"&_
				"				<option value='' selected>所有商品类别下</option>"
  								sql="select cid,prod_class_name from prod_class order by cid desc"
  								set rs=conn.execute (sql)
 	 							set cid=rs(0)
  								set prod_class_name=rs(1)
  								do while not rs.eof
  									response.write  "<option value="&cid&">"&prod_class_name&"</option>"
 				 				rs.movenext
 				 				loop
  				 				rs.close
  				 				set rs=nothing
response.write 	"		 		</select>"&_
				"		 	</td>"&_
				"		</tr>"&_
				"		<tr><td>&nbsp;商品名称包含:</td><td><input type=text name=name size=30> 匹配多个关键字全部，可用空格或 AND 连接。</td></tr>"&_
				"		<tr><td>&nbsp;商品内容包含:</td><td><input type=text name=detail size=30></td></tr>"&_
				"		<tr><td>&nbsp;商品价格(本站价):</td><td><input size=6 name=UserPriceMin>元(小值)&nbsp; 至 <input size=6 name=UserPriceMax>元(大值)</td></tr>"&_
				"		<tr><td>&nbsp;商品特性:</td><td><input type=checkbox name=flag1 value=1>推荐&nbsp; <input type=checkbox name=flag2 value=2>新品 <input type=checkbox name=flag value=3>特价</td></tr>"&_
				"		<tr><td>  </td><td><input type=submit value='开始搜索'></td></tr>"&_
				"		</form>"&_
				"	</table>"&_
				"</div>"
Footer
%>