<% Dim ConnectionString set objConn = Server.CreateObject("ADODB.Connection") 'define connection string, specify database driver and location of the database objConn.open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=213.171.200.85; PORT=3306; DATABASE=villas; USER=Nick_P2; PASSWORD=nick753848x2; OPTION=3;" location = "Costa Calida" Onsite = "Yes" sql = "Select * from VillasFull" sql = sql & " Where Destination = " & "'" & location & "'" sql = sql & " And Live = " & "'" & Onsite & "'" Set villaRS = objConn.Execute (sql) %>

Villas With Pools

Villas With Pools

Costa Calida Villa Rental Holidays 2024/2025

Costa Calida Villa Rentals

Costa Calida Villas

<% while not villaRS.EOF %>
">" alt="<%=villaRS("VillaName")%>" class="img-responsive" title="Villa Rentals" border="0" />

<%=villaRS("VillaName")%>, <%=villaRS("Resort")%>

Sleeps: <%=villaRS("Sleeps")%>
Tour Operator: <%=villaRS("Top")%>

<%=villaRS("Description")%>

<% IF villaRS("Top") = "Olivers Travels" THEN %>

" target="new"> ">

<% ELSE %>

">

<% END IF %>

<% villaRS.MoveNext %> <% WEND %>

Costa Calida Resorts

La Manga

<% VillaRS.Close objConn.Close set villaRS = nothing set objConn = nothing %>