myguideWales - the vacation specialistsVacations in Wales
"; echo "
Vacations in Ireland
SEARCH




Meet the Team
Why MyGuide
Our Principles
Testimonials


South Wales
Mid Wales
North Wales

Visitor Attractions


Maps
Currency Converter
Distance Chart
Links Page
Track Shipment
Terms&Conditions
Travel Insurance

Rent A Phone
FAQ

 
 
'.ereg_replace("(\r\n|\r|\n)","

",$Textcontent).'

'; } // formulate the SQL query - images //$query = "SELECT filename, filetype, alt_text FROM image WHERE image.city_id = '$town' //" 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); // $image = $myrow["filename, filetype, alt_text"]; // memory flush pg_FreeResult($result); ?> HOME
: MID WALES

Mid Wales

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 "

"; //Use the following line for the geo-coord map //echo "

\"$Town_name\"
"; //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 "\"$Town_name\""; } //echo $Textcontent; echo "

"; //show the formatted region name in accommodation and town tables $RegionText = ucwords(str_replace("_", " ", $region)); ?>

Accommodation in the $RegionText region"; ?> "; ?>
Castles, Hotels, Cottages in Wales
Special CastlesStately HousesElegant PlacesLocal FavouritesSpeciality
Castles, Hotels, Cottages in Ireland
"; echo "
Towns in the $RegionText region
"; 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 ""; echo "
Attractions in the $RegionText region
"; 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(); ?>

 



 


CALL TOLL-FREE
FROM U.S.

1877 205 5922
 
NEWSLETTER
 
Newsletter Sign-up
 
 

© 1 2 Travel (UK) ltd 2004
HOME : MID WALES EMAIL THIS PAGE
We Rated with RSACi


Home |
Who We Are | Contact us| Privacy Policy | FAQ

We are a member of
We are a member of IATA