主题:高手们帮看看,一段搜索功能的代码
想做一个能搜索房源功能的,价格和面积查询的,查询方式是这样的,如下
search.asp部分代码
<SELECT style="WIDTH: 60"><OPTION value="" selected>价格</OPTION><OPTION value=0-15>15万以下</OPTION><OPTION value=15-20>15-20万</OPTION><OPTION value=20-25>20-25万</OPTION><OPTION value=25-30>25-30万</OPTION><OPTION value=30-40>30-40万</OPTION><OPTION value=40-60>40-60万</OPTION><OPTION value=60-80>60-80万</OPTION><OPTION value=80-120>80-120万</OPTION><OPTION value=120-*>120万以上</OPTION></SELECT>
<SELECT style="WIDTH: 60px"> <OPTION value="" selected>面 积</OPTION><OPTION value=0-50>50平米以下</OPTION><OPTION value=50-70>50-70平米</OPTION><OPTION value=70-90>70-90平米</OPTION><OPTION value=90-120>90-120平米</OPTION><OPTION value=120-160>120-160平米</OPTION><OPTION value=160-*>160平米以上</OPTION></SELECT>
但在这里边的代码怎么写
search_sell.asp
部分代码如下:
<%
dim search,search_qy,search_lx,search_hx,search_zj,search_mj_min,search_mj_max,search_jg_min,search_jg_max
search_qy=request("search_qy")
search_lx=request("search_lx")
search_hx=request("search_hx")
search_zj=request("search_zj")
[color=FF0000]search_mj_min=trim(request("search_mj_min"))
search_mj_max=trim(request("search_mj_max"))
search_jg_min=trim(request("search_jg_min"))
search_jg_max=trim(request("search_jg_max"))[/color]
这四行代码应怎么改,才能完成上边的功能查询,这四行是手输入价格和面积的,就是把最低多少到最高多少的这样查询,现在想实现上边那种,应怎么实现,请高手帮看看
search=""
if request("search_qy")<>"" then
search=search & "and qy='" & request("search_qy") & "'"
end if
if request("search_lx")<>"" then
search=search & " and wylx='" & request("search_lx") & "'"
end if
if request("search_hx")<>"" then
search=search & " and hx='" & request("search_hx") & "'"
end if
if request("search_zj")<>"" then
search=search & " and zj='" & request("search_zj") & "'"
end if
if search_mj_min<>"" then
search=search & " and int(jz_area)>=int('" & search_mj_min & "')"
end if
if search_mj_max<>"" then
search=search & " and int(jz_area)<=int('" & search_mj_max & "')"
end if
if search_jg_min<>"" then
search=search & " and int(pay)>=int('" & search_jg_min & "')"
end if
if search_jg_max<>"" then
search=search & " and int(pay)<=int('" & search_jg_max & "')"
end if
%>
search.asp部分代码
<SELECT style="WIDTH: 60"><OPTION value="" selected>价格</OPTION><OPTION value=0-15>15万以下</OPTION><OPTION value=15-20>15-20万</OPTION><OPTION value=20-25>20-25万</OPTION><OPTION value=25-30>25-30万</OPTION><OPTION value=30-40>30-40万</OPTION><OPTION value=40-60>40-60万</OPTION><OPTION value=60-80>60-80万</OPTION><OPTION value=80-120>80-120万</OPTION><OPTION value=120-*>120万以上</OPTION></SELECT>
<SELECT style="WIDTH: 60px"> <OPTION value="" selected>面 积</OPTION><OPTION value=0-50>50平米以下</OPTION><OPTION value=50-70>50-70平米</OPTION><OPTION value=70-90>70-90平米</OPTION><OPTION value=90-120>90-120平米</OPTION><OPTION value=120-160>120-160平米</OPTION><OPTION value=160-*>160平米以上</OPTION></SELECT>
但在这里边的代码怎么写
search_sell.asp
部分代码如下:
<%
dim search,search_qy,search_lx,search_hx,search_zj,search_mj_min,search_mj_max,search_jg_min,search_jg_max
search_qy=request("search_qy")
search_lx=request("search_lx")
search_hx=request("search_hx")
search_zj=request("search_zj")
[color=FF0000]search_mj_min=trim(request("search_mj_min"))
search_mj_max=trim(request("search_mj_max"))
search_jg_min=trim(request("search_jg_min"))
search_jg_max=trim(request("search_jg_max"))[/color]
这四行代码应怎么改,才能完成上边的功能查询,这四行是手输入价格和面积的,就是把最低多少到最高多少的这样查询,现在想实现上边那种,应怎么实现,请高手帮看看
search=""
if request("search_qy")<>"" then
search=search & "and qy='" & request("search_qy") & "'"
end if
if request("search_lx")<>"" then
search=search & " and wylx='" & request("search_lx") & "'"
end if
if request("search_hx")<>"" then
search=search & " and hx='" & request("search_hx") & "'"
end if
if request("search_zj")<>"" then
search=search & " and zj='" & request("search_zj") & "'"
end if
if search_mj_min<>"" then
search=search & " and int(jz_area)>=int('" & search_mj_min & "')"
end if
if search_mj_max<>"" then
search=search & " and int(jz_area)<=int('" & search_mj_max & "')"
end if
if search_jg_min<>"" then
search=search & " and int(pay)>=int('" & search_jg_min & "')"
end if
if search_jg_max<>"" then
search=search & " and int(pay)<=int('" & search_jg_max & "')"
end if
%>