\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } $sql = "SELECT EstDetails.RecordID, EstDetails.Name, Town, county, CountyName, review, date FROM EstDetails INNER JOIN CountyDetails ON EstDetails.county = CountyDetails.RecordID INNER JOIN reviews ON reviews.est = EstDetails.RecordID WHERE EstDetails.RecordID IN ($text) ORDER BY CountyName, Name, date DESC"; $result = mysql_query($sql)or mailjim('result', "$sql\n".mysql_error()); $textarray = explode(',',$text); $last = end($textarray); $latest= mysql_query("SELECT Name FROM EstDetails WHERE RecordID = $last")or mailjim('result', "$sql\n".mysql_error()); ?> Where We've Been in England, Scotland, Wales and Offshore
Name' class='vmargin'>

$late->Name

"; ?>

Related links:

Restaurants | Reviews | Reports | Destinations | Hotels

Where Weve Been in Britain... Special Places

CountyName){ echo"$wb->CountyName | \n"; $ccheck = $wb->CountyName; } } mysql_data_seek($result, 0); echo'

'; $ccheck = ''; $namecheck = ''; while($wb = mysql_fetch_object($result)){ if($ccheck != $wb->CountyName){ echo"

$wb->CountyName

\n"; $ccheck = $wb->CountyName; } if($namecheck != $wb->Name){ $desc = ''; $description = explode(' ', $wb->review); $num = (count($description) < 25) ? count($description) : 25; for($i=0; $i<$num; $i++){$desc .= $description[$i].' '; } echo <<-->

$wb->Name, $wb->Town, $wb->CountyName
$desc...More

EOT; $namecheck = $wb->Name; } } ?>