Hay-on-Wye, Wales

"; echo "


	Advanced Search
	ABOUT US
	Who We Are Why MyGuide Our Principles Testimonials

	WALES
	South Wales Mid Wales North Wales Visitor Attractions

	TRAVEL TOOLS
	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 : : ".(strtoupper ($region)).""?>:

"; 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"; ?> "; ?>

Special Castles • Stately Houses • Elegant Places • Local Favourites • Speciality •

"; 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
EMAIL US

VACATION ENQUIRY

	VACATION SPECIALISTS
	Meet the team!

NEWSLETTER

		subscribe
		unsubscribe
WHY SUBSCRIBE ?

EMAIL THIS PAGE

We are a member of