<?php
header('Content-Type: text/html; charset=iso-8859-1');
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once  $path."/connect_db.php";
//get the GET parameter from URL
$id = $_GET["hint"];
$pieces = explode("|", $id);

if($pieces[2]=='ireland'){
// city
$sql = $connect->query("SELECT * FROM 2city WHERE area_grandad='{$pieces[0]}' ORDER BY area_name ASC");
}else{
// town
$sql = $connect->query("SELECT * FROM 3town WHERE area_grandad='{$pieces[0]}' ORDER BY area_name ASC");
}

echo 'Business Town / Area*:<br><div class="cnTitleDesc">Please select the area of your business.</div>';
echo '<select size="1" class="txbox" name="town">';
echo '<option value selected>Select area</option>';
while($row = $sql->fetch_array()){
	if($row['city_name']){
		$city_name_display=' - '.$row['city_name'];
		$city_name=$row['city_name'];
	}else{
		$city_name='';
	}
	echo '<option value="'.$row['area_id'].'|'.$row['area_lon'].'|'.$row['area_lat'].'|'.$city_name.'|'.$row['area_name'].'">'.$row['area_name'].$city_name_display.'</option>';
	$county_name = $row['area_name'];
	$city_name = $row['city_name'];
}
echo '</select>';
?>