"; //$mysqli = new mysqli("213.171.200.94","fozfoz","Timeshare1066!","Expectations"); $mysqli = new mysqli("localhost:3306","fozfozfozfoz","Xo#3p0u2","Expectations"); if($searchByFlag){ //$query = mysqli_query($mysqli, "SELECT * FROM resorts WHERE flagGolfing = 1"); //$query = mysqli_query($mysqli, "SELECT * FROM resorts WHERE " . $searchTheme . " = 1"); //$query = mysqli_query($mysqli, "SELECT * FROM resorts WHERE $searchTheme = 1 AND flagLive = 1"); $query = mysqli_query($mysqli, "SELECT * FROM resorts WHERE $searchTheme = 1 AND flagLive = 1 ORDER BY RAND()"); } else{ $query = mysqli_query($mysqli, "SELECT * FROM resorts WHERE continent = '$searchTheme' AND flagLive = 1 ORDER BY RAND()"); } if(mysqli_num_rows($query) > 0) { // Results to show while($row = mysqli_fetch_array($query)) { //echo $row['flagGolfing']; $listResortName = $row['resortName']; $listContinent = $row['continent']; $listCountry = $row['country']; $listRegion = $row['region']; $listSeoName = $row['seoName']; $flagAllInclusive = $row['flagAllInclusive']; $flagLateDeals = $row['flagLateDeals']; $flagExtraHolidays = $row['flagExtraHolidays']; $listResortNameAlt = str_replace("'", "", $listResortName); switch ($searchTheme) { case 'flagMembersSpecials': $directory = "members-specials"; break; case 'flagRentals': $directory = "rentals"; break; default: $directory = "holidays"; } $markup .= ""; $markup .=""; $markup .=""; return $markup; } ?>

Discover Australia & Oceania In Luxury

Join now

Australia, New Zealand, Fiji, Samoa

Sydney Harbour, the Opera House, Bondi Beach…The sights and sounds of Australia make for the start of a fantastic Expectations holiday, ‘Down Under’. Australasia is a fascinating part of the world that includes Australia, New Zealand and many islands in the Pacific Ocean.

On Holiday in ‘Oz!

Choose a five day tour of the massive country and continent of Australia; from the sparse and rugged ‘outback’ to the bustling cities of Sydney, Melbourne and Perth. What about booking your Expectations holiday to coincide with some of the great sporting events held annually in Australia? Why not splurge out on a once in a lifetime holiday to the Great Barrier Reef?

New Zealand Adventure Holidays

New Zealand holds the title of the adventure capital of the southern hemisphere. Choose a South Island whale watching tour or an alpine ski experience before spending a few days in Wellington or Auckland.

Island Fantasy

Samoa, Fiji, and the islands of the South Seas beckon when you select one of the excellent Expectations holiday resorts in Australasia. Deep seas diving, achingly azure seas and pristine beaches; a perfect combination of 5-star resorts and island life is waiting for you at any time of the year when you use your points through Expectations Holidays.