Jag har en sökmotor KODEN
//
<!-- #include virtual="/land/adovbs.stm" -->
<% Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=D:/clients/xxx/wwwroot/databas/search.mdb"
If Request.Form("fsearch") <> "" Then
SQL = "SELECT * From search1 WHERE country LIKE '" & Request.Form("fsearch")& "%' OR province LIKE '" & Request.Form("fsearch")& "%'OR city LIKE '" & Request.Form("fsearch")& "%'"
set rs=Connect.Execute(SQL)
if not rs.eof then
do until rs.eof
%><a href="detail.asp?id=<%=rs("ID")%>"><%=rs("country")%>, <%=rs("province")%> <%=rs("city")%> </a><br><%=rs("bedf")%> Fullsize bed's, <%=rs("xbed")%> Extra bed's<br>
Price High: <%=rs("high")%>, Low: <%=rs("low")%><br><BR>
<%rs.movenext
loop
end if
else
%>Dident find any house's in the country/City<%
end if
rs.close
set rs=Nothing
Connect.close
set connect=nothing
%>
//
men jag vill att man ska typ kunna söka
Sverige +Lund
Bara med + Inget annat.
------------------
Lazerzubb