\r\n";
mail('jim.rolt@googlemail.com', $subject, $error, $headers);
}
if(isset($_GET['id']) && is_numeric($_GET['id'])){$id = $_GET['id'];}else{$id = 1;}
$q = mysql_query("SELECT SQL_CACHE Haunted.*, CountyName, bcomregion FROM Haunted
LEFT JOIN CountyDetails ON CountyDetails.RecordID = Haunted.county
WHERE id = $id")or mailjim("q", mysql_error());
$title = mysql_fetch_object($q);
$sql = "SELECT content, Entered, reviewer FROM Feedback WHERE link = '".mysql_real_escape_string($_SERVER['REQUEST_URI'])."' AND displayed = 1 ORDER BY Entered DESC";
$fb = mysql_query($sql)or mailjim('Feedback', "$sql\n".mysql_error());
$sql = "SELECT id, title FROM Haunted ORDER BY title";
$hl = mysql_query($sql)or mailjim('Feedback', "$sql\n".mysql_error());
$pageurl = $_SERVER['REQUEST_URI'];
$cpcount = mysql_query("UPDATE pagecounter SET pagecount=pagecount+1 WHERE pageurl = '$pageurl'");
if(mysql_affected_rows()==0){$cpcount = mysql_query("INSERT INTO pagecounter(pageurl, pagecount, firstday) VALUES
('$pageurl', 1, NOW())");}
$cq = mysql_query("SELECT pagecount FROM pagecounter WHERE pageurl = '$pageurl' ");
$gcq = mysql_fetch_object($cq);
$vcount = $gcq->pagecount;
echo <<
British History |
Events |
Lore & Legend |
Rather Interesting
$title->town, $title->CountyName From $feed->reviewer on $edate
id'>$row->title ';
$count ++;
}
?>
Related links:
More British Ghost Stories?
EOT;
echo nl2br($title->content).'$feednum $response to $title->title
\n";
while($feed = mysql_fetch_object($fb)){
$edate = date('jS F Y', strtotime($feed->Entered));
echo"
$feed->contentMore Haunted Britain
";
if($count == $num)echo'