<?php
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
$radius=100;
$kilometers=6371; // reference to calculate with kilometers
$miles=3959; // reference to calculate with miles


$query = "SELECT *, ( {$miles} * acos( cos( radians(' ".mysqli_real_escape_string($connect,$lat)." ') ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(' ".mysqli_real_escape_string($connect,$long)." ') ) + sin( radians(' ".mysqli_real_escape_string($connect,$lat)." ') ) * sin( radians( latitude ) ) ) )
				AS distance 
				FROM ads 		
				WHERE `active`='1' AND adid!='{$adid}'
				HAVING distance < '".mysqli_real_escape_string($connect,$radius)."' 				
				ORDER BY distance 
				LIMIT 0 , 6";

$query_result = $connect->query($query) or die($connect->error); 			
	
$nearby_business.='<div class="cn_shaddow cont_cn" style="padding:0px;width:245px;">';
$nearby_business.='<div class="heading" style="padding:15px 15px 5px;font-size:11pt;color:#D64136;">Businesses Near '.$town_name.'</div><div class="ln_height">';
$nearby_business.='<table class="relatedBusiness" width="100%">';
$num_row_near=$query_result->num_rows;
if($num_row_near==0){
	$nearby_business.='<tr><td style="text-align:center;color: #555;background: #FDFDFD;">No near by businesses.</td></tr>';
}else{
	while ($row = $query_result->fetch_array()){
		$r_adid=strtolower($row['adid']);
		$r_ad_name=strtolower($row['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);
		$promo_bg = ($i++ & 1) ? '#fff' : '#fafafa'; // background alternator
		$nearby_business.='<tr>';
		$nearby_business.='<td valign="middle" style="text-align:center;height:50px;width:50px;background:'.$promo_bg.'">';
		
		if($row['image']!=''){
			$nearby_business.= '<img width="50" style="border:1px solid #d1d1d1;" src="/members/uploads/logo/'.$row['adid'].'.jpg">';
		}else{
			$nearby_business.= '<img width="50" style="border:1px solid #d1d1d1;" src="/img/no_logo.png">';
		}

		$nearby_business.='</td>';	
		$nearby_business.='<td style="background:'.$promo_bg.'" valign="middle">';
			$nearby_business.='<a style="font-size:10pt;font-weight:bold;" href="/pages/'.$r_adid.'-'.$ad_name.'.html">'.$row['companyname'].'</a>';
			$nearby_business.='<div style="color:#333;font-size:9pt">'.round($row['distance'], 1).'mi from '.$town_name.'.</div>';
		$nearby_business.='</td>';
		$nearby_business.='</tr>';
	}
}
$nearby_business.='</table></div></div>';


?>