<?
session_start();
include_once('../connect.php'); 

$id=ucwords(str_replace('-',' ',$_GET['id']));


// pagination settings
$current_page=(int)$_GET['page']; // setting as integer
if(empty($current_page)||$current_page<=0){$current_page=1;}
$per_page=20;
$per_page_db=$per_page+1;
$start=($current_page-1) * $per_page;
$next=$current_page+1;
$prev = ($current_page >= 0  ? $current_page-1 : $current_page);
$counter=0;

$yadsq3 = mysql_query("SELECT * FROM ads WHERE `county_name`='{$id}' AND `active`='1' ORDER BY adid DESC LIMIT {$start}, {$per_page_db}") or die(mysql_error()); 
$check = mysql_num_rows($yadsq3); if ($check===0) {header('Location: http://www.yellowleaf.co.uk/'); die; }
while($row = @mysql_fetch_array($yadsq3)){ foreach( $row AS $key => $val ){  $$key = stripslashes( $val ); } 
	$counter++; // pagin counter
	if($counter<$per_page){
		$r_ad_name=strtolower($companyname);
		$r_ad_name = preg_replace("/[^A-Za-z 0-9]/", "", $r_ad_name); $r_ad_name=str_replace("  "," ",$r_ad_name);
		$ad_name=str_replace(" ","-",$r_ad_name);
		
		$subDesc=substr($description,0,200);
		if(strlen($str)<200){$desc=$subDesc.'...';}else{$desc=$description;}
		
		$subArea=substr($areas_cover,0,100);
		if(strlen($str)<200){$Area=$subArea.'...';}else{$Area=$areas_cover;}
		
		if ($street2) {$fulladd=ucwords(strtolower("$street1, $street2, $town_name, $county_name, "));} else {$fulladd=ucwords(strtolower("$street1, $town_name, $county_name, "));}
		
		$result .= '<div class="sresult curv3">
		<table width="100%">
		<tr>
		<td width="90" valign="middle" style="text-align:center;padding:17px 4px;">';
		if($image !=''){
			$result .= '<img width="70" src="/members/uploads/logo/'.$adid.'.jpg">';
		}else{
			$result .= '<img width="70" style="border:1px solid #d1d1d1;" src="/img/no_logo.png">';
		}
		$result .= '</td><td valign="top" style="padding:10px;">
			<a style="font-size:16pt;" href="/pages/'.$adid.'-'.$ad_name.'.html">'.$companyname.', '.$town_name.',  '.$id.'</a>
			<div style="padding-top:5px;font-size:10pt;color:#555;"><b>'.$fulladd.' '.strtoupper($postcode).'.</b></div>
			<div style="margin:5px 0px;color:#666;font-size:10pt;">'.$desc.' '.$Area.'</div></td></tr>
			<tr><td valign="middle" style="text-align:right;padding:5px 10px 10px;" colspan="2">
			<a href="/pages/'.$adid.'-'.$ad_name.'.html" class="button blue curv3">view this business</a></td></tr></table></div>';
	}

}


//## pagin prev
if($prev>=1&&$counter>0){
if ($prev==1) {$pagin_prev.='<a class="button blue curv3" style="margin-right:15px" href="'.str_replace('?page=2','',$_SERVER["REQUEST_URI"]).'">< Previous Page</a>';} else {$pagin_prev.='<a class="button blue curv3" style="margin-right:15px" href="?page='.$prev.'">< Previous Page</a>';}
}else{
	$pagin_prev.='<a class="button inactive curv3" style="margin-right:15px">< Previous Page</a>';
}

//## pagin next
if($counter>$per_page&&$counter>0){
	$pagin_next.='<a class="button blue curv3" href="?page='.$next.'">Next Page ></a>';
}else{
	$pagin_next.='<a class="button inactive curv3">Next Page ></a>';
}

$murl= preg_replace("/\?page\=(.*)/i", "", $_SERVER["REQUEST_URI"]);
$remove_id = str_replace('Greater ','',$id);
$title ="Businesses in $id";
if($current_page>1){
$page_no =" Page ".$current_page;
}

// floating advertise button on right
if(isset($_SESSION['ename'])||isset($_COOKIE['yl_user'])){$yleaf_url='/members/';}else{$yleaf_url='/advertise/';}
$provided_by_btn='<a style="border:0px;outline:none;" href="'.$yleaf_url.'">
				<img src="/img/providedby.png" onmouseover="this.src=\'/img/providedby_hover.png\'" onmouseout="this.src=\'/img/providedby.png\'" style="border:0;outline:none;">
				</a>';

$tplbody= file_get_contents("results_tpl.html");
$header= file_get_contents("../header2.php");
$footer= file_get_contents("../footer.php");
include_once('../top_bar2.php'); 
$tplbody = str_replace("{top_bar}", "$top_bar", $tplbody);
$tplbody = str_replace("{provided_by_btn}", "$provided_by_btn", $tplbody);
$tplbody = str_replace("{header}", "$header", $tplbody);
$tplbody = str_replace("{footer}", "$footer", $tplbody);

$tplbody = str_replace("{title}", $title, $tplbody);
$tplbody = str_replace("{page_no}", $page_no, $tplbody);
$tplbody = str_replace("{results}", $result, $tplbody);
$tplbody = str_replace("{pagin_prev}", $pagin_prev, $tplbody);
$tplbody = str_replace("{pagin_next}", $pagin_next, $tplbody);
$tplbody = str_replace("{county}", "$remove_id", $tplbody);
$tplbody = str_replace("{murl}", "$murl", $tplbody);

$tplbody = str_replace("{type}", "$cattype", $tplbody);
$tplbody = str_replace("{area_found}", "$area_found", $tplbody);
$tplbody = str_replace("{longlat}", "$longlat", $tplbody);

$tplbody = str_replace("{suggest}", $suggest, $tplbody);
 


$outputline = split("\n",$tplbody); foreach ($outputline as $line) {
if (trim($line)) { echo trim($line); echo " "; } 
}


?>