$content_html_text
$locations_links$num_results boats found: Currently displaying $startpos to $maxpos.
$back $next
$remove_keywords
1234.00
}
function format_number_0dp($str,$decimal_places='0',$decimal_padding="0"){
// --------- PROVIDED BY: jarratt at si-works dot net -------------------
/* firstly format number and shorten any extra decimal places */
/* Note this will round off the number pre-format $str if you dont want this fucntionality */
$str = number_format($str,$decimal_places,'.',''); // will return 12345.67
$number = explode('.',$str);
$number[1] = (isset($number[1]))?$number[1]:''; // to fix the PHP Notice error if str does not contain a decimal placing.
$decimal = str_pad($number[1],$decimal_places,$decimal_padding);
return (float) $number[0];
// example: format_number_2dp('1234'); --> 1234.00
}
// =============================================================================
// =============== GRAB URL ADDITIONAL DETAILS ===========================
// =============================================================================
$criteria = " WHERE properties.hold=1 ";
$content = "default"; // only to be able to run a non-matching query - may later use a default
$hiddenfields = "";
// this is for daily weekly select box on the filter
if(isset($_GET['regularity']) && $_GET['regularity']>-1){
$criteriadaily = " AND (properties.typeofbooking = ". $_GET['regularity'] . " ) ";
$regularity = $_GET['regularity'];
if($regularity==0){
$daysel = " SELECTED ";
} else{
$weeksel = " SELECTED ";
}
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= "(properties.typeofbooking = $regularity )";
$linktext .= "regularity=$regularity&";
$hiddenfields .= "";
} // EO regularity
if(isset($_GET['crewtype']) && $_GET['crewtype']>-1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$crewtype = $_GET['crewtype'];
if($crewtype==1){
$search_text .= " bareboat yachts ";
$baresel = " SELECTED ";
} else{
$search_text .= " crewed yachts ";
$crewsel = " SELECTED ";
}
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteriaskipper = " AND (property_extended.b1 = $crewtype ) ";
$criteria_array['crewtype'] = $crewtype;
$criteria .= "(property_extended.b1 = $crewtype )";
$linktext .="crewtype=$crewtype&";
$hiddenfields .= "";
} // EO new crewtype
if(isset($_GET['minpax']) && $_GET['minpax']>-1){
$minpax = $_GET['minpax'];
if(strlen($search_text)>0){
$search_text .= " and can carry at least $minpax passengers ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria_array['minpax'] = $minpax;
$criteria .= "(property_extended.b10 >= $minpax )";
$linktext .="minpax=$minpax&";
$hiddenfields .= "";
} // EO new crewtype
if($_GET['furlingmainsail']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " parcare=1 ";
$linktext .= "furlingmainsail=1&";
$search_text .= " with furling mainsail ";
} // --amenity
if($_GET['entertainment']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " tv=1 ";
$linktext .= "entertainment=1&";
$search_text .= " with entertainment system ";
} // --amenity
if($_GET['waterski']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " masinaspalat=1 ";
$linktext .= "waterski=1&";
$search_text .= " with water skis ";
} // --amenity
if($_GET['events']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " animale=1 ";
$linktext .= "events=1&";
$search_text .= " suitable for events & meetings ";
} // --amenity
if($_GET['internet']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " internet=1 ";
$linktext .= "internet=1&";
$search_text .= " with internet ";
} // --amenity
if($_GET['satphone']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " telefon=1 ";
$linktext .= "satphone=1&";
$search_text .= " with satelite telephone ";
} // --amenity
if($_GET['gps']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " piscina=1 ";
$linktext .= "gps=1&";
$search_text .= " with GPS ";
} // --amenity
if($_GET['manufacturer']>0){
$manufacturer = $_GET['manufacturer'];
$ser = mysql_query("SELECT manufacturer FROM boat_manufacturers WHERE manufacturer_id='$manufacturer'");
$res = mysql_fetch_array($ser, MYSQL_ASSOC);
$manufacturer_text = $res['manufacturer'];
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " boat_models.manufacturer_id=$manufacturer ";
$linktext .= "manufacturer=$manufacturer&";
$search_text .= " manufacturered by $manufacturer_text ";
} // --amenity
if($_GET['handicap']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " handicap=1 ";
$linktext .= "handicap=1&";
$search_text .= " that is a classic yacht ";
} // --amenity
if($_GET['autpilot']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities1=1 ";
$linktext .= "autpilot=1&";
$search_text .= " with autopilot ";
} // --amenity
if($_GET['ssbvhf']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities2=1 ";
$linktext .= "ssbvhf=1&";
$search_text .= " with SSB, VHF ";
} // --amenity
if($_GET['jetski']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities3=1 ";
$linktext .= "jetski=1&";
$search_text .= " with jetski ";
} // --amenity
if($_GET['scuba']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities4=1 ";
$linktext .= "scuba=1&";
$search_text .= " with scuba gear ";
} // --amenity
if($_GET['bbq']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities5=1 ";
$linktext .= "bbq=1&";
$search_text .= " with BBQ ";
} // --amenity
if($_GET['jacuzzi']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities6=1 ";
$linktext .= "jacuzzi=1&";
$search_text .= " with jacuzzi ";
} // --amenity
if($_GET['jacuzzi']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities6=1 ";
$linktext .= "jacuzzi=1&";
$search_text .= " with jacuzzi ";
} // --amenity
if($_GET['snorkel']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities9=1 ";
$linktext .= "snorkel=1&";
$search_text .= " with snorkelling gear ";
} // --amenity
if($_GET['aircon']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities10=1 ";
$linktext .= "aircon=1&";
$search_text .= " with air conditioning ";
} // --amenity
if($_GET['sport_fish']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$hiddenfields .= "";
$criteria .= " amenities_fishing=1 ";
$linktext .= "sport_fish=1&";
$search_text .= " suitable for sport fishing ";
} // --amenity
if($_GET['racing']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " racing=1 ";
$linktext .= "racing=1&";
$search_text .= " available for racing ";
} // --amenity
if($_GET['greatvalue']==1){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= " customamenities7=1 ";
$linktext .= "greatvalue=1&";
$search_text .= " ";
} // --amenity
if($_GET['sortprice']=='desc'){
$orderstring = "pprice DESC, properties.pprice2 DESC, ";
$biaisorder = "";
$descsel = " SELECTED ";
} else{
if(isset($_GET['sortprice']) && strlen($_GET['sortprice'])>0){
$biaisorder = "";
$ascsel = " SELECTED ";
} else{
$biaisorder .= ", ";
}
$orderstring = "pprice ASC, properties.pprice2 ASC, ";
}
if(isset($_GET['luxury'])){
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " luxury yachts ";
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= "(properties.luxury ='1')";
$linktext .= "luxury=1&";
$content = "%luxury%";
$hiddenfields .= "";
} // EO model
if(isset($_GET['model'])){
$model = $_GET['model'];
$model = str_replace('"',"%",$model);
$model = str_replace("'","%",$model);
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " model is '$model' ";
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$criteria .= "(boat_models.model LIKE '%$model%')";
$linktext .= "model=$model&";
$content = "%$model%";
$hiddenfields .= "";
} // EO model
if(isset($_GET['water'])){
$water = $_GET['water'];
$water = str_replace('"',"%",$water);
$water = str_replace("'","%",$water);
$selectedplace = $water;
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " in $water ";
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
// $criteria .= "(ajt_ports.body_of_water = '$water')";
// $criteria .= "(property_extended2.additional_ports LIKE '%$water%)'";
$linktext .= "water=$water&";
$content = "%$water%";
$hiddenfields .= "";
} // EO port
if(isset($_GET['region'])){
$region = $_GET['region'];
$region = str_replace('"',"%",$region);
$region = str_replace("'","%",$region);
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " in $region ";
$selectedplace = $region;
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
// $criteria .= "(ajt_ports.region = '$region')";
// $criteria .= "(property_extended2.additional_ports LIKE '%$region%)'";
$linktext .= "region=$region&";
$content = "%$region%";
$hiddenfields .= "";
} // EO port
if(isset($_GET['country'])){
$country = $_GET['country'];
$port = str_replace('"',"%",$country);
$country = str_replace("'","%",$country);
$selectedplace = $country;
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " in $country ";
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
// $criteria .= "(ajt_ports.country = '$country')";
// $criteria .= "(property_extended2.additional_ports LIKE '%$country%')";
$linktext .= "country=$country&";
$content = "%$country%";
$hiddenfields .= "";
} // EO port
if(isset($_GET['port'])){
$port = $_GET['port'];
$port = str_replace('"',"%",$port);
$port = str_replace("'","%",$port);
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " in $port ";
$selectedplace = $port;
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
// $criteria .= "(ajt_ports.port = '$port')";
// $criteria .= "(property_extended2.additional_ports LIKE '%$port%')";
$linktext .= "port=$port&";
$content = "%$port%";
$hiddenfields .= "";
} // EO port
if(isset($_GET['allwords'])){
$allwords = $_GET['allwords'];
$linktext .= "allwords=$allwords&";
$hiddenfields .= "";
}
if($_GET['boattype']>-1 || $_GET['overboatttype']>-1){
if(isset($_GET['overboattype'])){
$boattype = $_GET['overboattype'];
} else{
$boattype = $_GET['boattype'];
}
switch($boattype){
case 1:
$boattypetext = 'motor yachts';
break;
case 2:
$boattypetext = 'sail yachts';
break;
case 3:
$boattypetext = 'catamarans';
break;
}
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " $boattypetext ";
$criteriaboat_type = " AND (properties.typeofproperties = $boattype ) ";
$criteria .= " AND properties.typeofproperties = $boattype ";
$linktext .="boattype=$boattype&";
$criteria_array['boattype'] = $boattype;
} // EO. if isset
if($_GET['overlength']>-1 || $_GET['length']>1){
if($_GET['overlength']>-1){
$length = $_GET['overlength'];
$linktext .= "overlength=$overlength&";
$criteria .= " AND properties.sleeps >= $overlength ";
$hiddenfields .= "";
} else{
$length = $_GET['length'];
$criteria .= " AND properties.sleeps = $length ";
$linktext .="overlength=$overlength&";
$hiddenfields .= "";
}
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " more than $length metres ";
} // EO. if isset
if($_GET['cabins']>-1 || $_GET['overcabins']>-1){
$biaisorder = "";
$orderstring = " (property_extended.b13*1) ASC, ";
$cabinscheck = true;
if(isset($_GET['overcabins'])){
$cabins = $_GET['overcabins'];
} else{
$cabins = $_GET['cabins'];
}
if($cabins==5){
$criteriacabins = " AND property_extended.b13 >= $cabins ";
$criteria .= " AND property_extended.b13 >= $cabins ";
} else{
$criteriacabins = " AND property_extended.b13 >= $cabins ";
$criteria .= " AND property_extended.b13 >= $cabins ";
}
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " yachts with $cabins or more cabins ";
$linktext .="cabins=$cabins&";
$criteria_array['cabins'] = $cabins;
}
if(isset($_GET['chartable'])){
$chartable = $_GET['chartable'];
$criteria .= " AND properties.typeofbooking = $chartable";
$linktext .="chartable=$chartable&";
$hiddenfields .= "";
}
if(isset($_GET['classic'])){
$classic = $_GET['classic'];
$criteria .= " AND properties.handicap = $classic";
$linktext .="chartable=$classic&";
$hiddenfields .= "";
}
if(isset($_GET['hot'])){
$hot = $_GET['hot'];
$criteria .= " AND properties.customamenities8 = $hot";
$linktext .="hot=$hot&";
$hiddenfields .= "";
}
if(isset($_GET['aircon'])){
$aircon = $_GET['aircon'];
$criteria .= " AND properties.customamenities10 = $aircon";
$linktext .="aircon=$aircon&";
$hiddenfields .= "";
}
if(isset($_GET['jacuzzi'])){
$jacuzzi = $_GET['jacuzzi'];
$criteria .= " AND properties.customamenities6 = $jacuzzi";
$linktext .="jacuzzi=$jacuzzi&";
$hiddenfields .= "";
}
if(isset($_GET['events'])){
$events = $_GET['events'];
$criteria .= " AND properties.animale = $events";
$linktext .="events=$events&";
$hiddenfields .= "";
}
if(isset($_GET['locations']) && $_GET['locations']!='All'){
$locations = $_GET['locations'];
$locations = str_replace("`","%",$locations);
$locations = str_replace('"',"%",$locations);
$locations = str_replace('%20'," ",$locations);
if(strlen($search_text)>0){
$search_text .= " and ";
} // EO text
$search_text .= " in $locations";
$locations_header = ucwords(strtolower(": $locations"));
$selectedplace = $locations;
if(strlen($criteria)>0){
$criteria .= " AND ";
} else{
$criteria .= " WHERE ";
}
$linktext .= "locations=$locations&";
if($locations=="UK"){
$criteria .= " (ajt_ports.port = '$locations' OR ajt_ports.country='$locations' OR regions.region_name = '$locations' OR ajt_ports.body_of_water='$locations' ) ";
$criterialocations = " AND regions.region_name='$locations' ";
} else{
$criteria .= " (ajt_ports.port LIKE '%$locations%' OR ajt_ports.country LIKE '%$locations%' OR regions.region_name LIKE '%$locations%' OR ajt_ports.body_of_water LIKE '%$locations%' ) ";
$criterialocations = " AND regions.region_name LIKE '%$locations%' ";
}
$criteria_array['locations'] = $locations;
$content = "%$locations%";
$biaisorder = "port_bias2 DESC, $biaisorder";
$extrajoins = "LEFT JOIN ajt_boat_ports ON ajt_boat_ports.boat_id = properties.pid LEFT JOIN ajt_ports ON ajt_boat_ports.port_id = ajt_ports.port_id LEFT JOIN regions ON ajt_ports.region_id = regions.region_id";
$maxports = ", MAX( CASE WHEN ajt_ports.port='$locations' THEN ajt_boat_ports.port_bias ELSE 0 END) AS port_bias2 ";
if($deep_search==1){
$locations_header = ucwords(strtolower(": $locations"));
// ---- build contextual links -----
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=1 AND sleeps>20 AND typeofbooking=1") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
$locations_links1 .= "Motor";
} // EO if super mega motor
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=2 AND sleeps>20 AND typeofbooking=1") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
if(strlen($locations_links1)>0){ $locations_links1 .= " | "; }
$locations_links1 .= "Sail";
} // EO if super mega sail
if(strlen($locations_links1)>0){
$locations_links .= "Super and Mega Yachts: $locations_links1
";
}
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=1 AND b1=1") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
$locations_links2 .= "Bareboat";
} // EO if motor bareboat
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=1 AND b1=2") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
if(strlen($locations_links2)>0){ $locations_links2 .= " | "; }
$locations_links2 .= "Crewed";
} // EO if motor crewed
if(strlen($locations_links2)>0){
$locations_links .= "Motor Boats: $locations_links2
";
}
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=2 AND b1=1") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
$locations_links3 .= "Bareboat";
} // EO if motor bareboat
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=2 AND b1=2") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
if(strlen($locations_links3)>0){ $locations_links3 .= " | "; }
$locations_links3 .= "Crewed";
} // EO if motor crewed
if(strlen($locations_links3)>0){
$locations_links .= "Monohull Sailboats: $locations_links3
";
}
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=3 AND b1=1") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
$locations_links4 .= "Bareboat";
} // EO if motor bareboat
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=3 AND b1=2") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
if(strlen($locations_links4)>0){ $locations_links4 .= " | "; }
$locations_links4 .= "Crewed";
} // EO if motor crewed
if(strlen($locations_links4)>0){
$locations_links .= "Catamarans: $locations_links4
";
}
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND animale=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=1") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
$locations_links5 .= "Motor";
} // EO if events bareboat
$test1 = mysql_query("SELECT COUNT(*) AS total FROM properties LEFT JOIN property_extended ON properties.pid =property_extended.id LEFT JOIN property_extended2 ON properties.pid = property_extended2.pid WHERE hold=1 AND animale=1 AND additional_ports LIKE '%$locations%' AND typeofproperties=2") or die(mysql_error());
$result = mysql_fetch_array($test1, MYSQL_ASSOC);
if($result['total'] > 0){
if(strlen($locations_links5)>0){ $locations_links5 .= " | "; }
$locations_links5 .= "Sail";
} // EO if events crewed
if(strlen($locations_links5)>0){
$locations_links .= "Yachts for Special Events: $locations_links5
";
}
if(strlen($locations_links)>0){ $locations_links = "
Sort through the boats below or use these handy links to quickly find the boats that best fit your needs:
$locations_links
$content_html_text
$locations_links$num_results boats found: Currently displaying $startpos to $maxpos.
$back $next
$remove_keywords