\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } $place = is_numeric($_GET['place']) ? $_GET['place'] : 1; include'dataedit/sql.php'; $type = isset($_GET['type']) ? $_GET['type'] : 1; switch($type){ case 2: $sql = "SELECT reviews.name AS reviewer, DATE_FORMAT(reviews.date, '%D %M, %Y') AS sdate, review, associd, showt, Shops.Name, Address1, Address2, Town, Postcode, web AS Website, CountyName, CountyDetails.CountryID, bcomregion, County FROM Shops INNER JOIN reviews ON reviews.est = Shops.ID AND reviews.display = 1 AND reviews.type = 2 INNER JOIN CountyDetails ON CountyDetails.RecordID = Shops.County WHERE Shops.ID = '$place' Order By date DESC "; break; case 3: $sql = "SELECT reviews.name AS reviewer, DATE_FORMAT(reviews.date, '%D %M, %Y') AS sdate, review, associd, showt, Sports.Name, Address AS Address1, Address2, Town, Postcode, Website, CountyName, CountyDetails.CountryID, CountyNameCut, bcomregion, County FROM reviews INNER JOIN Sports ON reviews.est = Sports.ID AND Sports.ID = '$place' INNER JOIN CountyDetails ON CountyDetails.RecordID = Sports.County WHERE reviews.display = 1 AND reviews.type = 3 Order By date DESC "; break; case 4: $sql = "SELECT reviews.name AS reviewer, DATE_FORMAT(reviews.date, '%D %M, %Y') AS sdate, review, associd, showt, events.event AS Name, Town, CountyName, CountyNameCut, CountyDetails.CountryID, bcomregion, County FROM reviews INNER JOIN events ON reviews.est = events.eventid INNER JOIN CountyDetails ON CountyDetails.RecordID = events.County WHERE reviews.display = 1 AND reviews.est = '$place' AND reviews.type = 4 Order By date DESC "; break; default: $sql = "SELECT reviews.name AS reviewer, DATE_FORMAT(reviews.date, '%D %M, %Y') AS sdate, review, associd, showt, EstDetails.Name, Address1, Address2, Town, Postcode, Website, CountyName, CountyNameCut, CountyDetails.CountryID, bcomregion, county, EstDetails.Description FROM reviews INNER JOIN EstDetails ON reviews.est = EstDetails.RecordID INNER JOIN CountyDetails ON CountyDetails.RecordID = EstDetails.County WHERE reviews.display = 1 AND est = '$place' Order By date DESC "; } //echo $sql; $rq = mysql_query($sql)or die("$sql\n".mysql_error()); $result = mysql_fetch_assoc($rq); echo << Reviews of {$result['Name']}, {$result['Town']}, {$result['CountyName']} EOT; ?>
"; } ?>

It is important to remember that for every bad review there are probably lots of satisfied customers. These reviews are the comments of individual visitors to Information Britain and have not been authenticated by us. They should not be taken as the views of Crawbar Ltd - publishers of this web site.

'' && $result['county'] > 0){ include'towndrop.php'; towndrop($result['county'], $result['CountyNameCut']); } include'locallinks.php'; $llins = new locallinks($result['county'],$result['CountryID']); echo $llins->output; ?>

Reviews of '.$result['Name'].''; if($result['Town']){ echo', '; if(in_array(1, $esorter[$result['Town']]) || in_array(12, $esorter[$result['Town']]) || in_array(5, $esorter[$result['Town']])){ echo"{$result['Town']}"; } elseif(key_exists($result['Town'], $esorter)){ echo"'.$result['Town'].''; } else{echo $result['Town'];} } echo "

\n"; include'linkunit.txt'; include'newbcombox.php'; newbox($result['Town'], $result['bcomregion']); include'google_line_2015.txt'; if(mysql_num_rows($rq) > 0){mysql_data_seek($rq, 0);} while($reviews = mysql_fetch_assoc($rq)){ if(!empty($reviews['reviewer'])){ echo'
Review by '.$reviews['reviewer'].''; } else{ echo'
Anonymous Review'; } if($reviews['sdate']){echo' on '.$reviews['sdate'].'';} echo"
\n

Add your review
". $reviews['review']."

\n
"; } echo"

- Write a Review

\n"; if($bvnt->num > 0){ $pts = $bvnt->num == 1 ? 'place' : 'places'; echo"

We have $bvnt->num $pts to stay in {$result['Town']}

\n"; } //include'adviva468.txt'; ?>