';
$query = mysql_query("select siteID from campsites where (name like '%".mysql_real_escape_string($_GET["search"])."%' or address like '%".mysql_real_escape_string($_GET["search"])."%') and enabled = 1 order by premium desc limit ".(($_GET["page"]-1)*PAGE_LIST).", ".PAGE_LIST.";");
//echo "select name from campsites where address like '%".$_GET["county"]."%' limit ".(($_GET["page"]-1)*PAGE_LIST).", ".($_GET["page"]*PAGE_LIST).";";
while($result = mysql_fetch_array($query)) {
$site = new site_listing($result["siteID"], 1, $user->data['user_id']);
$content .= $site->return_listing().' ';
}
}
else {
if($_GET["tents"]) {
$query_bits[] = "tents = 1";
}
if($_GET["caravans"]) {
$query_bits[] = "caravans = 1";
}
if($_GET["toilets"]) {
$query_bits[] = "toilets = 1";
}
if($_GET["showers"]) {
$query_bits[] = "showers = 1";
}
if($_GET["fires"]) {
$query_bits[] = "fires = 1";
}
if($_GET["all_year"]) {
$query_bits[] = "open_value = 1";
}
if($_GET["adults"]) {
$query_bits[] = "adults = 1";
}
if($_GET["laundry"]) {
$query_bits[] = "laundry = 1";
}
if($query_bits) {
$query = mysql_query("select count(siteID) from campsites where (name like '%".mysql_real_escape_string($_GET["adv_search"])."%' or address like '%".mysql_real_escape_string($_GET["adv_search"])."%') and enabled = 1 and ".implode(" and ", $query_bits)." order by premium desc;");
}
else {
$query = mysql_query("select count(siteID) from campsites where (name like '%".mysql_real_escape_string($_GET["adv_search"])."%' or address like '%".mysql_real_escape_string($_GET["adv_search"])."%') and enabled = 1 order by premium desc;");
}
$result = mysql_fetch_array($query);
$record_count = $result["count(siteID)"];
$page_count = ceil($record_count/PAGE_LIST);
$page_numbers = '';
if($_GET["page"]>1) {
$page_numbers .= ' ';
}
for($i=0; $i<$page_count; $i++) {
if(($i+1)==$_GET["page"]) {
$page_numbers .= ''.($i+1).' ';
continue;
}
$page_numbers .= ''.($i+1).' ';
}
$page_numbers = trim($page_numbers);
if($_GET["page"]<$page_count) {
$page_numbers .= ' ';
}
$content .= '';
$content .= '
'.($page_numbers).'
'.google_ads("horiz").'
';
if($query_bits) {
$query = mysql_query("select siteID from campsites where (name like '%".mysql_real_escape_string($_GET["adv_search"])."%' or address like '%".mysql_real_escape_string($_GET["adv_search"])."%') and enabled = 1 and ".implode(" and ", $query_bits)." order by premium desc limit ".(($_GET["page"]-1)*PAGE_LIST).", ".PAGE_LIST.";");
}
else {
$query = mysql_query("select siteID from campsites where (name like '%".mysql_real_escape_string($_GET["adv_search"])."%' or address like '%".mysql_real_escape_string($_GET["adv_search"])."%') and enabled = 1 order by premium desc limit ".(($_GET["page"]-1)*PAGE_LIST).", ".PAGE_LIST.";");
}//echo "select name from campsites where address like '%".$_GET["county"]."%' limit ".(($_GET["page"]-1)*PAGE_LIST).", ".($_GET["page"]*PAGE_LIST).";";
$content .= '
';
}
$content .= '';
$content .= '