Central
Wales is an area of rolling valleys and vast lakes basking in serenity
that lies virtually undiscovered.
The mid
Wales area stretches from the Marches along the English borders to
Cardigan Bay in the West sparsely populated with small market towns,
rural villages and coastal communities. It forms much of the vast
ancient Welsh kingdom of Powys and the fabulous castle and gardens
of Powis, once home to the Prince of Powys, are one of Wales’
most beautiful.
The
interior around the Elan Valley is spectacular driving country taking
you around stunning vistas of towering slopes and deep river valleys
that collect into a succession of impressive reservoirs built in
the early 20th Century.
This
region is Wales at its most rural and least populated where you’ll
see lush green valleys full of sheep but may not a single person
all day! Of those that live in mid Wales three in five have Welsh
as a first language, which can be heard as much in the rural villages
as the principle towns of Aberystwyth and Machynlleth.
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();
?>
|