configure('javascript URI', '../../'); function CountryChanged($country) { global $conn; $blank='"; $endhtml=''; $provinces=''; $provinces.=''; while ($regtown = mysql_fetch_array($result)){ $provinces .= ''; } $objResponse = new xajaxResponse(); $html=$tophtml.$provinces.$endhtml; $objResponse->assign('select_province_div', 'innerHTML', $html); $html=$blank.$endhtml; $objResponse->assign('select_town_div', 'innerHTML', $html); $objResponse->assign('select_suburb_div', 'innerHTML', $html); $objResponse->assign('select_georegion_div', 'innerHTML', $html); $objResponse->assign('select_touristregion_div', 'innerHTML', $html); $objResponse->assign('select_localregion_div', 'innerHTML', $html); return $objResponse; } function ProvinceChanged($province) { global $conn; $blank='"; $endhtml=''; $towns=''; $towns.=''; while ($regtown = mysql_fetch_array($result)){ $towns .= ''; } $objResponse = new xajaxResponse(); $html=$tophtml.$towns.$endhtml; $objResponse->assign('select_town_div', 'innerHTML', $html); $query="SELECT distinct region FROM destinations WHERE province = '$province' and region > ' ' order by region"; $result = mysql_query($query,$conn) or die(mysql_error()); $tophtml2=''; $regions=''; $regions.=''; while ($regtown = mysql_fetch_array($result)){ $regions .= ''; } $html=$tophtml2.$regions.$endhtml2; $objResponse->assign('select_region_div', 'innerHTML', $html); $html=$blank.$endhtml; $objResponse->assign('select_suburb_div', 'innerHTML', $html); $objResponse->assign('select_localregion_div', 'innerHTML', $html); return $objResponse; } function TownChanged($town) { global $conn; $blank=''; $endhtml=''; $suburbs=''; $suburbs.=''; while ($regtown = mysql_fetch_array($result)){ $suburbs .= ''; } $objResponse = new xajaxResponse(); $html=$tophtml.$suburbs.$endhtml; $objResponse->assign('select_suburb_div', 'innerHTML', $html); return $objResponse; } function RegionChanged($region) { global $conn; $blank=''; $endhtml=''; $localregions=''; $localregions.=''; while ($regtown = mysql_fetch_array($result)){ $localregions .= ''; } $query="SELECT distinct subregion2 FROM destinations WHERE region = '$region' and subregion2 > ' ' order by subregion2"; $result = mysql_query($query,$conn) or die(mysql_error()); while ($regtown = mysql_fetch_array($result)){ $localregions .= ''; } $objResponse = new xajaxResponse(); $html=$tophtml.$localregions.$endhtml; $objResponse->assign('select_localregion_div', 'innerHTML', $html); return $objResponse; } function Feature1Changed($feature) { global $conn; $blank=''; $endhtml=''; $featurevalues=''; $featurevalues.=''; while ($value = mysql_fetch_array($result)){ $featurevalues .= ''; } $objResponse = new xajaxResponse(); $html=$tophtml.$featurevalues.$endhtml; $objResponse->assign('select_feature1item_div', 'innerHTML', $html); return $objResponse; } function Feature2Changed($feature) { global $conn; $blank=''; $endhtml=''; $featurevalues=''; $featurevalues.=''; while ($value = mysql_fetch_array($result)){ $featurevalues .= ''; } $objResponse = new xajaxResponse(); $html=$tophtml.$featurevalues.$endhtml; $objResponse->assign('select_feature2item_div', 'innerHTML', $html); return $objResponse; } function Feature3Changed($feature) { global $conn; $blank=''; $endhtml=''; $featurevalues=''; $featurevalues.=''; while ($value = mysql_fetch_array($result)){ $featurevalues .= ''; } $objResponse = new xajaxResponse(); $html=$tophtml.$featurevalues.$endhtml; $objResponse->assign('select_feature3item_div', 'innerHTML', $html); return $objResponse; } $reqCountryChanged =& $xajax->registerFunction('CountryChanged'); $reqCountryChanged->setParameter(0, XAJAX_INPUT_VALUE, 'select_country'); $reqProvinceChanged =& $xajax->registerFunction('ProvinceChanged'); $reqProvinceChanged->setParameter(0, XAJAX_INPUT_VALUE, 'select_province'); $reqRegionChanged =& $xajax->registerFunction('RegionChanged'); $reqRegionChanged->setParameter(0, XAJAX_INPUT_VALUE, 'select_region'); $reqTownChanged =& $xajax->registerFunction('TownChanged'); $reqTownChanged->setParameter(0, XAJAX_INPUT_VALUE, 'select_town'); $reqFeature1Changed =& $xajax->registerFunction('Feature1Changed'); $reqFeature1Changed->setParameter(0, XAJAX_INPUT_VALUE, 'select_feature1'); $reqFeature2Changed =& $xajax->registerFunction('Feature2Changed'); $reqFeature2Changed->setParameter(0, XAJAX_INPUT_VALUE, 'select_feature2'); $reqFeature3Changed =& $xajax->registerFunction('Feature3Changed'); $reqFeature3Changed->setParameter(0, XAJAX_INPUT_VALUE, 'select_feature3'); $xajax->processRequest(); // passed the ajax functions session_start(); $offset=$_REQUEST['offset']; if($offset=="") {$offset=0;} $offsetminus20=$offset - 20; $offsetplus20=$offset + 20; $select_country=$_REQUEST['select_country']; if($select_country == "") { $select_country = "South Africa"; } $select_province=$_REQUEST['select_province']; if($select_province == "any") { $select_province = ""; } $select_region=$_REQUEST['select_region']; if($select_region == "any") { $select_region = ""; } $select_localregion=$_REQUEST['select_localregion']; if($select_localregion == "any") { $select_localregion = ""; } $select_town=$_REQUEST['select_town']; if($select_town == "any") { $select_town = ""; } $select_suburb=$_REQUEST['select_suburb']; if($select_suburb == "any") { $select_suburb = ""; } $select_price=$_REQUEST['select_price']; if($select_price == "any") { $select_price = ""; } $select_ratesfrom=$_REQUEST['select_ratesfrom']; if($select_ratesfrom == "any") { $select_ratesfrom = ""; } $select_ratesto=$_REQUEST['select_ratesto']; if($select_ratesto == "any") { $select_ratesto = ""; } $select_accommodation=$_REQUEST['select_accommodation']; if($select_accommodation == "any") { $select_accommodation = ""; } $select_grading=$_REQUEST['select_grading']; if($select_grading == "any") { $select_grading = ""; } $select_style=$_REQUEST['select_style']; if($select_style == "any") { $select_style = ""; } $select_feature1=$_REQUEST['select_feature1']; $select_feature1item=$_REQUEST['select_feature1item']; if($select_feature1 == "any") { $select_feature1 = ""; $select_feature1item = ""; } $select_feature2=$_REQUEST['select_feature2']; $select_feature2item=$_REQUEST['select_feature2item']; if($select_feature2 == "any") { $select_feature2 = ""; $select_feature2item = ""; } $select_feature3=$_REQUEST['select_feature3']; $select_feature3item=$_REQUEST['select_feature3item']; if($select_feature3 == "any") { $select_feature3 = ""; $select_feature3item = "";} $select_sleepsfrom=$_REQUEST['select_sleepsfrom']; if($select_sleepsfrom == "any") { $select_sleepsfrom = ""; } $select_sleepsto=$_REQUEST['select_sleepsto']; if($select_sleepsto == "any") { $select_sleepsto = ""; } $select_specialoffers=$_REQUEST['select_specialoffers']; $select_sort=$_REQUEST['select_sort']; if($select_sort == "") {$select_sort = "sortrank"; } $fixselect_accommodation=""; $fixselect_style=""; $fixselect_country="South Africa"; $fixselect_province="Eastern Cape"; $fixselect_region="Wild Coast"; $fixselect_localregion=""; $fixselect_town=""; $fixselect_suburb=""; $select_province="Eastern Cape"; $select_country="South Africa"; $select_region="Wild Coast"; ?> Wild Coast Accommodation printJavascript(); ?>

Search for Wild Coast Accommodation

"") { echo '
'.$errmsg.'
'; } ?>
">
By Country:
"") { echo "$fixselect_country"; echo ''; } else { ?>
 
By Province:
"" ) { echo "$fixselect_province"; echo ''; } else { ?>
 
Tourist Region:
"" || $fixselect_town > "") { echo "$fixselect_region"; echo ''; } else { ?>
By town:
"" || $fixselect_region > "") { echo "$fixselect_town"; echo ''; } else { ?>
Local Region:
"" || $fixselect_town > "" ) { echo "$fixselect_localregion"; echo ''; } else { ?>
By suburb:
"" || $fixselect_region > "") { echo "$fixselect_suburb"; echo ''; } else { ?>
Accommodation Type:
"" ) { echo "$fixselect_accommodation"; echo ''; } else { ?>
Style:
"" ) { echo "$fixselect_style"; echo ''; } else { ?>
Rates From:
Rates To:
Grading:
Only Special Offers: >

Sleeps
from:
To:
Extra features:
Sort by:

Wild Coast Accommodation listings

"") { $sqlquery.=" country = '$select_country' "; $flag=1; } if($select_province > "") { if($flag == 1) { $sqlquery.=" and "; } $sqlquery.=" province = '$select_province' "; $flag=1; } if($select_town > "") { if($flag == 1) { $sqlquery.=" and "; } $sqlquery.=" town = '$select_town' "; $flag=1; } if($select_suburb > "") { if($flag == 1) { $sqlquery.=" and "; } $sqlquery.=" suburb = '$select_suburb' "; $flag=1; } if($select_region > "") { if($flag == 1) { $sqlquery.=" and "; } $sqlquery.=" georegion = '$select_region' "; $flag=1; } if($select_localregion > "") { if($flag == 1) { $sqlquery.=" and "; } $sqlquery.=" ( touristregion = '$select_localregion' or localregion = '$select_localregion' ) "; $flag=1; } if($select_accommodation > "") { if($flag == 1) { $sqlquery.=" and "; } $sqlquery.=" accomtype like '%$select_accommodation%' "; $flag=1; } if($select_style > "") { if($flag == 1) { $sqlquery.=" and "; } $sqlquery.=" accomstyle like '%$select_style%' "; $flag=1; } if($select_ratesfrom > "" || $select_ratesto >"" ) { if($flag == 1) { $sqlquery.=" and "; } if($select_ratesfrom =="" ) { $sqlquery.=" ( ratesfrom > '0' "; } else if($select_ratesfrom == "R200") { $sqlquery.=" ( ratesfrom > '200' "; } else if($select_ratesfrom == "R300") { $sqlquery.=" ( ratesfrom > '300' "; } else if($select_ratesfrom == "R400") { $sqlquery.=" ( ratesfrom > '400' "; } else if($select_ratesfrom == "R500") { $sqlquery.=" ( ratesfrom > '500' "; } else if($select_ratesfrom == "R600") { $sqlquery.=" ( ratesfrom > '600' "; } else if($select_ratesfrom == "R800") { $sqlquery.=" ( ratesfrom > '800' "; } else if($select_ratesfrom == "R1000") { $sqlquery.=" ( ratesfrom > '1000' "; } if($select_ratesto =="" ) { $sqlquery.=" and ratesto < '99999999' ) "; } else if($select_ratesto == "R300") { $sqlquery.=" and ratesto < '300' ) "; } else if($select_ratesto == "R400") { $sqlquery.=" and ratesto < '400' ) "; } else if($select_ratesto == "R500") { $sqlquery.=" and ratesto < '500' ) "; } else if($select_ratesto == "R600") { $sqlquery.=" and ratesto < '600' ) "; } else if($select_ratesto == "R800") { $sqlquery.=" and ratesto < '800' ) "; } else if($select_ratesto == "R1000") { $sqlquery.=" and ratesto < '1000' ) "; } else if($select_ratesto == "R1500") { $sqlquery.=" and ratesto < '1500' ) "; } else if($select_ratesto == "R2000") { $sqlquery.=" and ratesto < '2000' ) "; } $flag=1; } if($select_grading > "") { if($flag == 1) { $sqlquery.=" and "; } if($select_grading == "3 & 4 star") { $sqlquery.=" ( grading like '%3 Star%' or grading like '%4 Star%' )"; } else if($select_grading == "4 star and better") { $sqlquery.= "( grading like '%4 Star%' or grading like '%5 Star%' )"; } else if($select_grading == "3 star and better") { $sqlquery.="( grading like '%3 Star%' or grading like '%4 Star%' or grading like '%5 Star%' )"; } else if($select_grading == "3 star and better") { $sqlquery.="( grading like '%3 Star%' or grading like '%4 Star%' or grading like '%5 Star%' )"; } else if($select_grading == "3 star") { $sqlquery.="( grading like '%3 Star%' )"; } else if($select_grading == "4 star") { $sqlquery.="( grading like '%4 Star%' )"; } else if($select_grading == "5 star") { $sqlquery.="( grading like '%5 Star%' )"; } else if($select_grading == "Portfolio Graded") { $sqlquery.="( grading like '%Portfolio Graded%' )"; } else if($select_grading == "AA Recommended") { $sqlquery.="( grading like '%AA Recommended%' or grading like '%AA Highly Recommended%' or grading like '%AA Superior%')"; } else if($select_grading == "AA Highly Recommended") { $sqlquery.="( grading like '%AA Highly Recommended%' or grading like '%AA Superior%' )"; } else if($select_grading == "AA Superior") { $sqlquery.="( grading like '%AA Superior%' )"; } else if($select_grading == "Greenwood Guides recommended") { $sqlquery.="( grading like '%Greenwood Guides recommended%' )"; } else $sqlquery .= " 1 "; $flag=1; } if($select_sleepsfrom > "" || $select_sleepsto >"" ) { if($flag == 1) { $sqlquery.=" and "; } if($select_sleepsfrom =="" ) { $sqlquery.=" ( maxbeds > '0' "; } else { $sqlquery.=" ( maxbeds > '$select_sleepsfrom' "; } if($select_sleepssto =="" ) { $sqlquery.=" and maxbeds < '99999999' ) "; } else if($select_sleepsto == "101") { $sqlquery.=" and maxbeds < '99999999' ) "; } else { $sqlquery.=" and maxbeds < '$select_sleepsto' ) "; } $flag=1; } if($select_feature1 > "" && $select_feature1item > "") { if($flag == 1) { $sqlquery.=" and "; } if($select_feature1 =="Activities" ) { $sqlquery.=" ( activitiesonpremisis like '%$select_feature1item%' or activitiesnearby like '%$select_feature1item%' )"; } elseif($select_feature1 =="Special Interests" ) { $sqlquery.=" specialinterests like '%$select_feature1item%' "; } elseif($select_feature1 =="Conference Facilities" ) { $sqlquery.=" conferencefacilities like '%$select_feature1item%' "; } elseif($select_feature1 =="Dinning Facilities" ) { $sqlquery.=" diningfacilities like '%$select_feature1item%' "; } elseif($select_feature1 =="Environment" ) { $sqlquery.=" environment like '%$select_feature1item%' "; } elseif($select_feature1 =="Languages Spoken" ) { $sqlquery.=" languagesspoken like '%$select_feature1item%' "; } elseif($select_feature1 =="Venue Facilities" ) { $sqlquery.=" venuefacilities like '%$select_feature1item%' "; } elseif($select_feature1 =="Room Facilities" ) { $sqlquery.=" roomfacilities like '%$select_feature1item%' "; } elseif($select_feature1 =="Wedding Facilities" ) { $sqlquery.=" weddingfacilities like '%$select_feature1item%' "; } elseif($select_feature1 =="Wellness Facilities" ) { $sqlquery.=" wellnessfacilities like '%$select_feature1item%' "; } else $sqlquery .= " 1 "; $flag=1; } if($select_feature2 > "" && $select_feature2item > "") { if($flag == 1) { $sqlquery.=" and "; } if($select_feature2 =="Activities" ) { $sqlquery.=" ( activitiesonpremisis like '%$select_feature2item%' or activitiesnearby like '%$select_feature2item%' )"; } elseif($select_feature2 =="Special Interests" ) { $sqlquery.=" specialinterests like '%$select_feature2item%' "; } elseif($select_feature2 =="Conference Facilities" ) { $sqlquery.=" conferencefacilities like '%$select_feature2item%' "; } elseif($select_feature2 =="Dinning Facilities" ) { $sqlquery.=" diningfacilities like '%$select_feature2item%' "; } elseif($select_feature2 =="Environment" ) { $sqlquery.=" environment like '%$select_feature2item%' "; } elseif($select_feature2 =="Languages Spoken" ) { $sqlquery.=" languagesspoken like '%$select_feature2item%' "; } elseif($select_feature2 =="Venue Facilities" ) { $sqlquery.=" venuefacilities like '%$select_feature2item%' "; } elseif($select_feature2 =="Room Facilities" ) { $sqlquery.=" roomfacilities like '%$select_feature2item%' "; } elseif($select_feature2 =="Wedding Facilities" ) { $sqlquery.=" weddingfacilities like '%$select_feature2item%' "; } elseif($select_feature2 =="Wellness Facilities" ) { $sqlquery.=" wellnessfacilities like '%$select_feature2item%' "; } else $sqlquery .= " 1 "; $flag=1; } if($select_feature3 > "" && $select_feature3item > "") { if($flag == 1) { $sqlquery.=" and "; } if($select_feature3 =="Activities" ) { $sqlquery.=" ( activitiesonpremisis like '%$select_feature3item%' or activitiesnearby like '%$select_feature3item%' )"; } elseif($select_feature3 =="Special Interests" ) { $sqlquery.=" specialinterests like '%$select_feature3item%' "; } elseif($select_feature3 =="Conference Facilities" ) { $sqlquery.=" conferencefacilities like '%$select_feature3item%' "; } elseif($select_feature3 =="Dinning Facilities" ) { $sqlquery.=" diningfacilities like '%$select_feature3item%' "; } elseif($select_feature3 =="Environment" ) { $sqlquery.=" environment like '%$select_feature3item%' "; } elseif($select_feature3 =="Languages Spoken" ) { $sqlquery.=" languagesspoken like '%$select_feature3item%' "; } elseif($select_feature3 =="Venue Facilities" ) { $sqlquery.=" venuefacilities like '%$select_feature3item%' "; } elseif($select_feature3 =="Room Facilities" ) { $sqlquery.=" roomfacilities like '%$select_feature3item%' "; } elseif($select_feature3 =="Wedding Facilities" ) { $sqlquery.=" weddingfacilities like '%$select_feature3item%' "; } elseif($select_feature3 =="Wellness Facilities" ) { $sqlquery.=" wellnessfacilities like '%$select_feature3item%' "; } else $sqlquery .= " 1 "; $flag=1; } $sqlquery.=" ) "; } $result=mysql_query($sqlquery,$conn) or die(__FILE__." Line:".__LINE__." mysql err:".mysql_error()."
sql=$sqlquery"); $total=mysql_num_rows($result); // total query must not have LIMIT if ($total < $to) $to = $total; //echo "debug:sql=$sqlquery
"; if (mysql_num_rows($result) < 1) { // so we have found no accommodation in a destination so lets do a search for estab name echo "

No results found for your search.

"; if($searchtype == "venuename" ) { echo "Try to seach for a portion of the name. You can also use the character '%' as a wild card which means you can find all the places that have the characters seached for with whatever is between them. This can help with miss spellings. "; } else { echo "Try to specify less in your selection top make your seach a little broader and perhaps also check that you dont contadict yourself with say a town that lies outside a specific region."; } } else { if($sortby > "") { $sqlquery .= " ORDER BY $sortby, venuename Asc, description Desc LIMIT $offset,20"; } else { $sqlquery .= " ORDER BY sortrank Desc, venuename Asc, description Desc LIMIT $offset,20"; } $result= mysql_query($sqlquery,$conn) or die(__FILE__." Line:".__LINE__." mysql err:".mysql_error()."
sql=$sqlquery"); ?>
0) { echo "Previous 20"; } ?> results to $total) {echo $total; } else {echo ($offset+20); } ?> of places found Next 20"; } ?>
sql=$query2"); echo "'; if($place_ratesfrom > 0) { echo "'; echo ''; } // end of while ?>
Rates'; } else if($sortby == "ratesfrom desc") { echo '
'; } ?>
"; $filename="../images/v$place_cid-1-s.jpg"; if (file_exists($filename)) { echo ''; } else { echo ''; } ?> ".$place_name ?> '; echo " ".$place_type." "."Accommodation"." accommodation in "; if($fixselect_suburb > "") { echo $fixselect_suburb; } else if($fixselect_town > "") { echo $fixselect_town; } else if($fixselect_localregion > "") { echo $fixselect_localregion; } else if($fixselect_region > "") { echo $fixselect_region; } else if($fixselect_province > "") { echo $fixselect_province; } else { echo $fixselect_country; } echo "
"; echo substr(strip_tags($place_description),0,270).'...
'; if($select_specialoffers == "Y") { echo "Special offer:$place_offer
"; } echo "
View Venue"; echo '
R$place_ratesfrom - R$place_ratesto
$place_ratesbasis
$place_ratesmeals
"; } else { echo "
$place_price
"; } echo ''.ceil($place_sortrank/10).'Rating
'.$place_valuerank.'Value'.'
0) { echo "Previous 20"; } ?> Next 20"; } ?>