<?

include_once('connect.php');


$area_sql = mysql_query("SELECT * FROM ads WHERE  boz = '1' ORDER BY adid ASC LIMIT 1");

if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){

$mid=$area_row['adid'];
$town_name =ucwords($area_row['town_name']);
$county_name  =ucwords($area_row['county_name']);
$postcode  =ucwords($area_row['postcode']);



echo "$mid";
echo "<hr>";
echo "$town_name";
echo "<hr>";
echo "<hr>";
echo "$county_name  ";
echo "<hr>";


//active = '0' AND active = '0' AND

}



$url = "http://maps.googleapis.com/maps/api/geocode/xml?address={$postcode}, UK&sensor=true"; 

    $mypix = simplexml_load_file($url);
	//print_r($mypix);

        $SellerRef=$mypix->result->address_component[1]->long_name;
		echo $SellerRef;
		$SellerRef = addslashes($SellerRef);

		
		
		





echo "UPDATE ads SET boz='{$found}' WHERE $adid='{$mid}'";
mysql_query("UPDATE ads SET boz='', town_name='{$SellerRef}' WHERE adid='{$mid}'");












?>

<meta http-equiv="refresh" content="0" />