|
The north of Wales is a land of majestic snowy mountain peaks and
imposing castle fortresses, a rugged enclave of Welsh language and
culture who like the landscape proved difficult to repress.
The
many 13th Century castles that ring the coastline of North Wales
were built by the English to subdue the Welsh Princes in their mountain
hideaways. These mighty fortresses were the very peak of military
planning in their day and are now designated UNESCO World Heritage
Sites.
The
mountains of Snowdonia are famous throughout the world for their
rugged peaks and horseshoe ridges, enchanting waterfalls and deep
wooded vales. The Welsh name for the region ‘Eryri’
means Place of Eagles and mount Snowdon, the tallest mountain in
England and Wales, dominates this sublime and awesome place in name
and in fame.
In
the Llyn Peninsula and on the Isle of Anglesey you will find some
of the most unspoilt areas of Wales where the Welsh language is
at its strongest. Indeed Anglesey is Mon Mam Cymru – Mother
of Wales and contains a wealth of Neolithic and early Celtic sites.
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();
?>
|