\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include('dataedit/sql.php'); if(!isset($_GET['county'])){ header("HTTP/1.1 404 Not Found"); header("Location: https://information-britain.co.uk/errordoc.php"); exit(); } $county = intval($_GET['county']); $sql = "SELECT DISTINCT ID, TYPE FROM EstablishmentType INNER JOIN EstDetails ON EstDetails.EstType = EstablishmentType.ID INNER JOIN CountyDetails ON (EstDetails.County = CountyDetails.RecordID OR EstDetails.County2 = CountyDetails.RecordID) AND List = 1 AND CountyDetails.RecordID = $county WHERE ID != 21 ORDER BY TYPE"; $est = mysql_query($sql)or mailjim('est', "$sql\n".mysql_error()); $sql = "SELECT DISTINCT ShopTypes.ID, ShopTypes.TYPE, CountyName, bcomregion FROM ShopTypes INNER JOIN Shops ON Shops.TYPE = ShopTypes.ID INNER JOIN CountyDetails ON CountyDetails.RecordID = $county AND Shops.County = CountyDetails.RecordID ORDER BY TYPE"; $shop = mysql_query($sql)or mailjim('shop', "$sql\n".mysql_error()); $byname = mysql_fetch_object($shop); if(mysql_num_rows($shop) > 0){mysql_data_seek($shop, 0);} $sql = "SELECT DISTINCT ActivityTypes.ID, ActivityTypes.TYPE FROM ActivityTypes INNER JOIN Activities ON Activities.TYPE = ActivityTypes.ID AND Activities.County = $county INNER JOIN CountyDetails ON CountyDetails.RecordID = Activities.County ORDER BY TYPE"; $act = mysql_query($sql)or mailjim('act', "$sql\n".mysql_error()); $sql = "SELECT DISTINCT SportTypes.ID, SportTypes.TYPE, SportTypes.Title FROM SportTypes INNER JOIN Sports ON Sports.TYPE = SportTypes.ID INNER JOIN CountyDetails ON CountyDetails.RecordID = $county AND Sports.County = CountyDetails.RecordID ORDER BY TYPE"; $spo = mysql_query($sql)or mailjim('spo', "$sql\n".mysql_error()); echo << Directory of Businesses in $byname->CountyName. Find $byname->CountyName Businesses EOT; ?>
CountyName, $byname->bcomregion); include'connect.php'; connect(); ?>
Directory of Businesses in $byname->CountyName"; include'linkunit.txt'; if(mysql_num_rows($est) > 0){ $count = 1; echo'

'; while($row = mysql_fetch_object($est)){ if($row->ID == 12){echo' Accommodation';} else{echo"ID\"> $row->TYPE\n";} if($count < mysql_num_rows($est)){echo' | ';} $count ++; } } if(mysql_num_rows($shop) > 0){ $count = 1; echo'

Shops:

'; while($row = mysql_fetch_object($shop)){ echo"ID&county=$county\"> $row->TYPE\n"; if($count < mysql_num_rows($shop)){echo' | ';} $count ++; } } if(mysql_num_rows($act) > 0){ $count = 1; echo'

Activities:

'; while($row = mysql_fetch_object($act)){ echo"ID\"> $row->TYPE\n"; if($count < mysql_num_rows($act)){echo' | ';} $count ++; } } if(mysql_num_rows($spo) > 0){ $count = 1; echo'

Sports:

'; while($row = mysql_fetch_object($spo)){ echo"ID&county=$county\"> $row->TYPE\n"; if($count < mysql_num_rows($spo)){echo' | ';} $count ++; } } echo"\n

Click for our main $byname->CountyName pages

"; include'dailyfeature.php'; ?>