// This lot connects to the database and pulls out all the countries for the dropdown box
// First open the database
$db = mysql_connect("localhost", "emed", "bollocks");
mysql_select_db("emed",$db);
$sql="SELECT * FROM chamber_locator_regions ORDER BY Region ASC";
$result=mysql_query($sql,$db);
$options="";
while ($row=mysql_fetch_assoc($result)) {
$ID=$row['Region_ID'];
$Country=$row['Region'];
$options.="
click on the required region or choose from the menu box.