"; $markup .= "

" . $heading . "

"; $markup .= "
"; $markup .= "
"; //$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 .= "
"; //if($rentals) //{ // $markup .= "
"; //} //else //{ // $markup .= "
"; //} $markup .= "
"; // Ready when all images/resorts have been added //if(!$searchByFlag || $flagAllInclusive || $flagLateDeals || $flagExtraHolidays) //{ // $markup .= "
"; //} //else //{ // $markup .= "
"; //} $markup .= "

" . $listResortName . " " . ucwords(str_replace("-", " ", $listRegion)) . "

"; $markup .= "

" . $row['metaDescription'] . "

"; //if($rentals) //{ //} //else //{ // $markup .= "Read more"; //} $markup .= "Read more"; $markup .= "
"; } } else { // No decords found! // Display somethings?? } $markup .="
"; $markup .="
"; $markup .="
"; $markup .="
"; return $markup; } ?> Expectations Members Area

Expectations Special Offers

0) { $i = 1; // Sound connection while($row = mysqli_fetch_array($query)) { $resortName = $row['resortName']; $pointsCost = $row['pointsCost']; $checkIn = date_create($row['checkIn']); $unitSize = $row['unitSize']; $resortSummary = $row['resortSummary']; $hypermarketWeek = $row['hypermarketWeek']; $priority = $row['priority']; $status = $row['status']; $weekImage = getWeekImage($hypermarketWeek); $checkIn = date_format($checkIn,"jS M Y"); if($i % 2 == 0) { echo "
"; echo "
"; echo "

" . $resortName . "" . $pointsCost . " points.

"; echo "

Check in: " . $checkIn . "
Unit size: " . $unitSize . "

"; echo "

" . $resortSummary . "

"; echo "
"; } else { echo "
"; echo "
"; echo "

" . $resortName . "" . $pointsCost . " points.

"; echo "

Check in: " . $checkIn . "
Unit size: " . $unitSize . "

"; echo "

" . $resortSummary . "

"; echo "
"; } $i++; } } ?>