\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } if(isset($_GET['town'])){ include('dataedit/sql.php'); $qtown = !empty($_GET['town']) ? mysql_real_escape_string($_GET['town']) : 'Worcester'; $uctown = ucwords($_GET['town']); $sql = "SELECT Name, postcode, telcode, CountyName, County FROM Towns LEFT JOIN CountyDetails ON CountyDetails.RecordID = Towns.County WHERE Name LIKE '%$qtown%' ORDER BY Name"; $tq = mysql_query($sql)or mailjim('tq', "$sql\n".mysql_error());//die("$sql
".mysql_error()); } ?> Find Postcodes and Dialling codes for UK Towns

Related links:

Attractions | Activities | Folk Customs | Theatres

0){ echo"

$uctown results:

\n"; include'linkunit.txt'; while($row = mysql_fetch_object($tq)){ echo"

$row->Name, $row->CountyName"; if(!empty($row->telcode)){echo"
Telphone dialling code: $row->telcode";} if(!empty($row->postcode)){echo"
Postcode: $row->postcode";} echo <<\nVisit our $row->Name Guide
$row->CountyName information

EOT; } } else{echo"

Sorry, we dont have any record of $uctown, please try again
\n";} } else { echo"

Free search - British post and telephone codes

"; include'linkunit.txt'; } ?>
Please Enter a Town Name: