| The
south of Wales is often characterised by its industrial south east
and its urban centres, but further west you will find picture postcard
coastline of sandy coves and dramatic cliff faces.
More
than half of Wales’ population live in the industrial landscapes
and urban centres of the South East, which includes Wales’
two largest cities of Swansea and Europe’s youngest capital
city Cardiff. Wales’ capital, like other capital cities, is
a vibrant centre for arts, culture and sport and much recent regeneration
has really put Cardiff on the European stage.
Industry
is an important part of Wales’ heritage and at one time the
country was the largest exporter of coal in the world. It’s
an industry that formed the life blood of the country up until this
Century and this is recognised in the small former mining town of
Blaenafon, now a UNESCO World Heritage Site and it’s ‘Big
Pit’ mining museum is one of the most interesting attractions
in Britain.
Getting
away from the hustle and bustle, the Gower Peninsula below Swansea,
may as well be another country, in another era. It’s a remote
place of upland moors and scenic coastline. Further west Pembrokeshire
virtually is another country, referred to as little England beyond
Wales, due to its history of colonisation. But you won’t find
a better coastline in England than along the Pembrokeshire Coast
National Park, with white sandy beaches, cliff stacks and breakneck
waves.
Though
South Wales is the most populated area only a tiny proportion speak
Welsh, found in quiet enclaves in Carmarthenshire.
echo " ";
echo "";
//Use the following line for the geo-coord map
//echo " ";
//echo "
".(strtoupper ($Town_name))." ";
//$image = "/images/db/".filename.filetype;
$townname = strtolower($Town_name);
$townname = str_replace(" ", "", $townname);
$Image_loc = "/home/sites/site5/web/images/wales/town/".$townname."_200.jpg";
$Image_web = "http://images.12travel.com/images/wales/town/".$townname."_200.jpg";
$fp = @fopen($Image_loc,"r");
if ($fp)
{
fclose ($fp);
echo " ";
}
//echo $Textcontent;
echo " | ";
//show the formatted region name in accommodation and town tables
$RegionText = ucwords(str_replace("_", " ", $region));
?>
// Region query
$query = "SELECT county.region_id FROM city , county WHERE
city_id = '$town' AND
city.county_id = county.county_id
" or die("Error in query");
//run the query on the database
$result = pg_exec($connection, $query) or die("Error in query");
$myrow = pg_fetch_array($result,0);
$reg_id = $myrow["region_id"];
// memory flush
pg_FreeResult($result);
// formulate the SQL query
$query = "SELECT city.name , city.city_id FROM city , county WHERE
city.county_id = county.county_id
AND county.region_id = $reg_id " or die("Error in query");
//run the query on the database
$result = pg_exec($connection, $query) or die("Error in query");
echo "";
echo "Towns in the $RegionText region | ";
echo "";
echo " ";
echo " ";
$limit = pg_numrows($result);
// with a while loop
// this loop will iterate as many times as there are records
while($numrow < $limit)
{
$myrow = pg_fetch_array($result, $numrow);
$Towns_name = $myrow["name"];
$Towns_id = $myrow["city_id"];
$numrow++;
$townsname = strtolower($Towns_name);
$townsname = str_replace(" ", "", $townsname);
echo "$Towns_name ";
}
echo " | ";
// formulate the SQL query
$query = "SELECT attraction.name_english , attraction.attraction_id FROM attraction, address, county WHERE
attraction.attraction_id = address.attraction_id
AND address.county_id = county.county_id
AND county.region_id = $reg_id " or die("Error in query");
//run the query on the database
$result = pg_exec($connection, $query) or die("Error in query");
echo "";
echo "Attractions in the $RegionText region | ";
echo "";
echo " ";
echo " ";
$limit = pg_numrows($result);
// with a while loop
// this loop will iterate as many times as there are records
$numrow = 0;
while($numrow < $limit)
{
$myrow = pg_fetch_array($result, $numrow);
$attraction_name = $myrow["name_english"];
$attraction_id = $myrow["attraction_id"];
$numrow++;
$attractionname = strtolower($attraction_name);
$attractionname = str_replace(" ", "", $attractionname);
echo "$attraction_name ";
}
echo " | ";
// memory flush
pg_FreeResult($result);
pg_Close();
?>
|