\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include'dataedit/sql.php'; $q = mysql_query("SELECT EstDetails.RecordID, EstDetails.Name, town, EstablishmentType.TYPE, Esttype, countyname, bcomregion FROM EstDetails INNER JOIN reviews ON reviews.est = EstDetails.RecordID AND reviews.display = 1 AND reviews.type = 1 INNER JOIN EstablishmentType ON EstablishmentType.ID = EstDetails.EstType INNER JOIN CountyDetails ON CountyDetails.RecordID = EstDetails.county WHERE county = $county ORDER BY Esttype, Name")or mailjim('q', mysql_error()); $check=''; $i=0; while($reviews = mysql_fetch_assoc($q)){ if($check != $reviews['RecordID']){ $data[$i]['RecordID'] = $reviews['RecordID']; $data[$i]['Name'] = $reviews['Name']; $data[$i]['town'] = $reviews['town']; $data[$i]['TYPE'] = $reviews['TYPE']; $data[$i]['number'] = '1'; $check = $reviews['RecordID']; $i++; $townlist[] = $reviews['town']; } else{ $dnum = count($data)-1; $data[$dnum]['number']++; } } $total = mysql_num_rows($q); mysql_data_seek($q, 0); $row = mysql_fetch_object($q); $q = mysql_query("SELECT events.eventid, event, town FROM events INNER JOIN reviews ON reviews.est = events.eventid AND reviews.display = 1 AND reviews.type = 4 WHERE county = $county ORDER BY event")or mailjim('q', mysql_error()); $check=''; $i=0; while($reviews = mysql_fetch_assoc($q)){ if($check != $reviews['eventid']){ $edata[$i]['RecordID'] = $reviews['eventid']; $edata[$i]['Name'] = $reviews['event']; $edata[$i]['town'] = $reviews['town']; $edata[$i]['number'] = 1; $check = $reviews['eventid']; $i++; $townlist[] = $reviews['town']; } else{ $dnum = count($edata)-1; $edata[$dnum]['number']++; } } $total = $total + mysql_num_rows($q); $townlist = array_unique($townlist); sort($townlist); echo << Visitor Reviews on our hotels, Inns, B&Bs, Pubs, restaurants and Bars in $row->countyname EOT; ?>
countyname'>\n

$row->countyname

\n"; } include'yellowbcombox.php'; yellowbox($row->countyname,$row->bcomregion); include'connect.php'; connect('', '', "$row->countyname Visitor Reviews"); ?>
Independent reviews of our $row->countyname establishments from our visitors.
We have $total reviews posted

Reviews by Town:

EOT; foreach($townlist as $tr){echo"$tr | \n";} echo '

'; $tcheck = ''; $counter = 0; for($j = 0; $j';} echo'

'.$data[$j]['TYPE']."

\n
    "; $tcheck = $data[$j]['TYPE']; } echo'
  • '.$data[$j]['Name'].''; if($data[$j]['town'])echo', '.$data[$j]['town']; echo' ('.$data[$j]['number'].")
    • \n"; $counter++; //every 10 lines put a to top link if(($counter % 20) == 0){ echo"To Top\n"; } } if(isset($edata)){ echo"

    Events\n"; $tcheck = ''; for($j = 0;$j'.$edata[$j]['Name'].''; if($edata[$j]['town'])echo', '.$edata[$j]['town']; echo' ('.$edata[$j]['number'].")\n"; $counter++; if(($counter % 10) == 0){ echo"To Top\n"; } } } ?>