get_results("SELECT accommodation.*,counties2.bb_dir AS bb_dir FROM accommodation INNER JOIN counties2 ON accommodation.County = counties2.name WHERE accommodation.Town = 'Chipping Sodbury' AND accommodation.County = 'Gloucestershire' AND (accommodation.AccommodationType = 'Bed and Breakfast' OR accommodation.AccommodationType = 'Guest House') GROUP BY BEid ORDER BY accommodation.HeritageRating DESC, accommodation.Name ASC, Source = 'LR' DESC, Source = 'EV' DESC")) { $County = $bbs[0]->County; $Country = $bbs[0]->Country; $Town = $bbs[0]->Town; // Include the pagination class include ("pagination.class.php"); // Create the pagination object $pagination = new pagination; // If we have an array with items if (count($bbs)) { // Parse through the pagination class $BBPages = $pagination->generate($bbs, 10); } //$titletag = 'Self Catering Cornwall, Self Catering Guide to Cornwall England'; //$metadescription = 'Self Catering Cottages in Cornwall, UK. Cornwall Self Catering Cottages with confirmed online booking in the Cornwall Travel Guide from Britain Express.'; //$metakeywords = 'Self Catering Cornwall Cottage Accommodation Cornwall uk cottages accommodation travel'; //$topblurb1 = 'Self Catering Cottages in Cornwall'; //$topblurb2 = 'Part of the Cornwall Travel Guide on Britain Express'; //$h1 = 'Self Catering cottages in Cornwall'; //$contentblurb = 'Here is a browseable listing of our self catering cottage locations // in Cornwall, England. Please select your desired location from the menu // below, or use the search form to the right. You may also wish to consult // the listings for nearby cottages in Devon // which borders on Cornwall. For alternative accommodation, see our Cornwall // hotel guide, and for suggestions on what to see and do in the area, // visit our Cornwall // Travel Guide'; //$regionalmenu = 'some stuff
'; //$regionalimage = '/counties/cornwall/images/St-Michaels-Mount/St-Michaels-Mount-0117-ss.jpg'; //$regionalimagealt = 'St Michael\'s Mount, Marazion, Cornwall'; //$photocredit = 'photo of St Michael\'s Mount, Cornwall, is © David Ross and Britain Express //'; // $extrapages = '/www/britainexpress/includes/Reading-Extrapages.htm'; include ("BB-Town-Template.htm"); } else { include ("BB-Towns-Template-none.htm"); } ?>