\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include'dataedit/sql.php'; $q = mysql_query("SELECT EstDetails.RecordID, EstDetails.Name, town, TYPE, Esttype, countyname, Country.Name AS countryname FROM EstDetails INNER JOIN menus ON menus.est = EstDetails.RecordID AND menus.web = '' INNER JOIN EstablishmentType ON EstablishmentType.ID = EstDetails.EstType AND EstablishmentType.ID != '2' INNER JOIN CountyDetails ON CountyDetails.RecordID = EstDetails.county INNER JOIN Country ON Country.ID = CountyDetails.CountryID ORDER BY Countryname, countyname, Esttype, town, Name")or mailjim('q', mysql_error()); ?> Sample menus from our hotels, Inns, B&B's, Pubs, restaurants and Bars

Related links:

Food legends | Gastropubs | Restaurants | Recipes

Sample menus from Britain's best hotels, inns and restaurants

'.$counties['countryname'].": \n"; $ccheck = $counties['countryname']; } if( $check != $counties['countyname']){ echo ''.$counties['countyname']." | \n"; $check = $counties['countyname']; } } mysql_data_seek($q,0); $check = ''; $ccheck = ''; $counter = '0'; while($counties = mysql_fetch_assoc($q)){ if( $ccheck != $counties['countryname']){ echo'

'.$counties['countryname']."

\n"; $ccheck = $counties['countryname']; } if( $check != $counties['countyname']){ echo'

'.$counties['countyname'].":

\n"; $check = $counties['countyname']; $tcheck = ''; } /* if($tcheck != $counties['TYPE']){ echo'

'.$counties['TYPE']."\n

'; include'books.txt'; include'dailyfeature.php'; ?>