search.asp

后台管理系统

<p class="sidebar-maintitle">Products Search</p>
<div class="title">
<form name="form1" method="get" action="serach_product.asp">
<p align="center"><b>KeyWord</b><br /><input name="keyword" type="text" class="wenbenkuang" id="keyword" size="18" ></p>
<p align="center"><b>SortID</b><br />
  <select name="sort_id" id="sort_id" class="wenbenkuang"dataType="Require"  msg="please select the sort！"  >
			  <option value="" selected="selected">select...</option>
			  <%
			  set rs1=server.CreateObject("adodb.recordset")
			  sql="select id,sort from product_sort order by sx asc"
			  rs1.open sql,conn,1,1
			  do while not rs1.eof %>
			  <option value="<%= rs1("id") %>" style="background-color:#f0f0f0"><%= rs1("sort") %></option>
			  
			  <% 
			  set rs2=server.CreateObject("adodb.recordset")
			  sql="select id,sort from product_small_sort where big_sortid="&rs1("id")&" order by sx asc"
			  rs2.open sql,conn,1,1
			  do while not rs2.eof %>
			  <option value="<%= rs2("id") %>">&nbsp;<%= rs2("sort") %></option>
			  <% rs2.movenext
			  loop
			  rs2.close
			  set rs2=nothing 
			   rs1.movenext
			  loop
			  rs1.close
			  set rs1=nothing %>
    </select></p>
<p align="center">
  <input type="submit" name="Submit" value="go" class="go-wenbenkuang"/>
</p>
</form>
			</div>