SQL搜索表单及符合条件的字段求和

来源：百度知道 编辑：UC知道 时间：2024/06/30 01:47:59
表单页
<form name="Search" method="post" action="sconn.asp">
<select name="tiaojian1" size="6" multiple class="inputxz50">
<option value=" taocan='65'">套餐55+10:3G</option>
<option value=" taocan='85'">套餐75+10:5G</option>
<option value=" taocan='115'">套餐105+10:11G</option>
<option value=" taocan='165'">套餐155+10:31G</option>
<option value=" taocan='60'">套餐50+10:1G</option>
<option value=" taocan='85.1'">套餐75+10:Um128</option>
</select>
<select name="tiaojian2" size="2" multiple class="inputxz50">
<option value="jiaoqianfou=true">交钱是</option>
<option value="jiaoqianfou=false">交钱否</opti

<%
t1=request.form("tiaojian1")
t1=Replace(t1,","," or ")
t2=request.form("tiaojian2")
t3=request.form("tiaojian3")
t3=Replace(t3,","," and ")

if t1="" and t2="" and t3="" then
response.Write "<script language='javascript'>alert('请选择搜索条件再提交');history.go(-1);</script>"
response.End
else
if t1="" and t2<>"" and t3<>"" then ord=" order by usernames asc"
if t1<>"" and t2="" and t3<>"" then ord=" order by taocan asc"
if t1<>"" and t2<>"" and t3="" then ord=" order by taocan desc"
if t1="" and t2<>"" and t3="" then ord=" order by taocan asc"
if t1="" and