if(isset($_GET['exec']))
{
    $q = mysql_query('SELECT id, postcode, town, region, country, country_string, longitude, latitude FROM zip_codes');
    $count = mysql_num_rows($q);
    $i = 0;
        
    while($data = mysql_fetch_assoc($q))
    {
        $data = array_map('trim', $data);
        mysql_query('UPDATE zip_codes SET postcode = \''.$data['postcode'].'\',  town = \''.$data['town'].'\', country = \''.$data['country'].'\', country_string = \''.$data['country_string'].'\', longitude = \''.$data['longitude'].'\', latitude = \''.$data['latitude'].'\'  WHERE id = \''.$data['id'].'\' LIMIT 1');
        if($i % 100 == 0) { sleep(5); }
        
        ++$i;
    }
}