<% 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 = "Ibiza" Onsite = "Yes" sql = "Select * from VillasFull" sql = sql & " Where Destination = " & "'" & location & "'" sql = sql & " And Live = " & "'" & Onsite & "'" sql = sql & " ORDER BY Sleeps " Set villaRS = objConn.Execute (sql) %>

Villas With Pools

Villas With Pools

Ibiza Villa Rental Holidays 2021/2022

Discover an island paradise with something for everyone – beautiful beaches, superb nightlife and stunning scenery – with a break in one of our villas in Ibiza.

There's more to Ibiza than clubbing. Hillside villages and secret coves are great for exploring, and when night comes the sunset is like no other. But if you do fancy a night on the town, from jazz to disco the island caters for all tastes.

Ibiza Villas

<% while not villaRS.EOF %>

<%=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 %>

Ibiza Resorts

San Juan - San Jose

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