search.asp

时代购物系统 4.0功能升级说明 <1>完善了3.0的VIP

<!--#include file="conn.asp"-->
<!--#include file="config.asp"-->
<title><%=webname%>--高级查询</title>
<SCRIPT LANGUAGE="JavaScript">
<!--
function checkk()
{
   if(checkspace(document.form2.searchkey.value))  {
	document.form2.searchkey.focus();
	alert("请输入查询关键字！");
	return false;
  }
   document.form2.submit();
}

//-->
</script>
<!--#include file="include/header.asp"--> 
<table width="760" border="0" align="center" cellpadding="0" cellspacing="1" BGCOLOR=<%=bgclr1%>> 
<tr> <td HEIGHT="20" align="center">
<FONT COLOR="#FFFFFF" SIZE="2"><B>高 级 查 询</B></FONT></td></tr> 
<tr> <td height="170" BGCOLOR=<%=bgclr4%>>
<table width="60%" border="0" align="center" cellpadding="1" cellspacing="1">
<form name="form2" method="post" action="research.asp"> 
<tr BGCOLOR=ffffff> <td width="20%" style="padding-left:6px">关 健 字：</td>
<td width="80%"  style="padding-left:6px"><input name="searchkey" type="text" id="searchkey"></td></tr> 
<tr BGCOLOR=ffffff> <td style="padding-left:6px">查找方式：</td>
<td style="padding-left:6px"><select name="action" id="action"> 
<option value="1" selected>商品名称</option> 
<option value="2">商品简介</option> 
<option value="3">详细说明</option> 
<option value="4">商品厂商</option> </select></td></tr> 
<tr BGCOLOR=ffffff> 
<td style="padding-left:6px">价格范围：</td>
<td style="padding-left:6px">
<select name="jiage" id="jiage">
<OPTION VALUE="1000">1000元以下</OPTION>
<OPTION VALUE="20">20元以下</OPTION>
<OPTION VALUE="30">30元以下</OPTION>
<OPTION VALUE="50">50元以下</OPTION>
<OPTION VALUE="100">100元以下</OPTION>
<OPTION VALUE="10000">10000以下</OPTION>
<OPTION VALUE="100000000">无限制</OPTION>
</select></td></tr> 
<tr BGCOLOR=ffffff> <td height="18" style="padding-left:6px">商品分类：</td>
<td style="padding-left:6px"> 
<%set rs=server.CreateObject("adodb.recordset")
		  rs.open "select * from category order by categoryorder",conn,1,1
		  %> <select name="categoryid"> <option value="0">查询所有分类</option> 
<%do while not rs.eof%> <option value="<%=rs("categoryid")%>"><%=trim(rs("category"))%></option> 
<%rs.movenext
		  loop
		  rs.close
		  set rs=nothing%> </select></td></tr> <tr BGCOLOR=ffffff> <td height="18" colspan="2" style="padding-left:6px"><div align="center"> 
<input type="submit" name="Submit" value="查  找" onclick="return checkk();"> </div></td></tr></form></table></td></tr> 
</table>
<!--#include file="include/footer.asp"-->