<%
q="select * from data where 1=1 "
if request("Hotel name") <> "" then
q=q & " and [hotel name]='" & request("hotel name") &"' "
end if
if request("city")<> "" then
q=q & " and city='" & request("city") &"' "
end if
if request("state")<> "" then
q=q & " and state='" & request("state") &"' "
end if
if request("category")<> "" then
q=q & " and category='" & request("category") &"' "
end if
set rs=conn.execute(q)
%>
indiaholidayplan.com, Kerala, Agra, Rajasthan, Goa, Varanasi, Khajuraho, Ajanta Ellora, Khajuraho
<%'%>
Search Results
<% if not rs.eof then%>
Hotel
Name
State
City
Details
<%
i=0
while not rs.eof
if i mod 2 =0 then
color="fde8f5"
else
color="d3ddfe"
end if
%>
