\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } $sql = "SELECT SQL_CACHE RecordID, CountyName FROM CountyDetails WHERE CountryID != 4 ORDER BY CountyName"; $zxcf = mysql_query($sql)or mailjim("headcounties", "$sql\n".mysql_error()); if(isset($_GET['id']) && is_numeric($_GET['id'])){$id = $_GET['id'];}else{$id = 1;} $q = mysql_query("SELECT famous.*, CountyName, bcomregion, Towns.ID AS tid FROM famous LEFT JOIN CountyDetails ON CountyDetails.RecordID = famous.birthcounty LEFT JOIN EstDetails ON (EstDetails.Town = famous.birthplace OR EstDetails.Town = famous.deathplace) LEFT JOIN Towns ON Towns.Name = famous.birthplace AND Towns.County = famous.birthcounty WHERE famous.id = $id GROUP BY birthplace DESC")or mailjim("q", mysql_error()); $title = mysql_fetch_object($q); $stown = mysql_real_escape_string($title->birthplace); if($title->deathcounty > 0){ $q2 = mysql_query("SELECT SQL_CACHE CountyName FROM CountyDetails WHERE RecordID = $title->deathcounty")or mailjim("q2", mysql_error()); $dc = mysql_fetch_object($q2); $deathcounty = $dc->CountyName; } if(!empty($stown)){ $sql = "SELECT SQL_CACHE DISTINCT EstType FROM EstDetails INNER JOIN CountyDetails ON (County = CountyDetails.RecordID OR County2 = CountyDetails.RecordID) AND CountyDetails.RecordID = $title->birthcounty WHERE List = 1 AND EstType IN(1,2,12) AND Town = '$stown' "; $chktown = mysql_query($sql)or mailjim("chktown", "$sql\n".mysql_error()); $chtown = array(); while($ets = mysql_fetch_object($chktown)){ $chtown[]= $ets->EstType; } } if(!empty($title->deathplace) ){ $sql = "SELECT SQL_CACHE ID FROM Towns WHERE Name = '$title->deathplace' AND County = $title->deathcounty"; $dtcheck = mysql_query($sql)or mailjim('dtcheck', "$sql\n".mysql_error()); } $sql = "SELECT SQL_CACHE quote FROM Quotes WHERE famousperson = '$id'"; $fq = mysql_query($sql)or mailjim('fq', "$sql\n".mysql_error()); echo << $title->name quotes. EOT; ?>

Related links

British History - Famous dates - Cultural Britain - Monarchs

\n"; } include'connect.php'; connect('', '', "Quotations from $title->name"); if(!empty($title->birthplace)){ include'yellowbcombox.php'; yellowbox($title->birthplace,$title->bcomregion); } ?>
$title->name Quotes\n"; include'linkunit.txt'; ?>

More Quotes

'$quot->quote'

\n"; } if(!empty($title->birthplace)){echo"

Born in "; $townurl = ucwords(trim(strtolower(str_replace('-', ' ', $title->birthplace))));//get rid of white space, allow for different capitalisation and hyphens/spaces if($title->tid){//theres a town table entry echo"$title->birthplace"; } elseif($chtown){ echo'
birthcounty\">$title->birthplace"; } else{echo"
$title->birthplace";} } if(!empty($title->birthplace) && !empty($title->CountyName)){echo',';} if(!empty($title->CountyName)){echo" $title->CountyName\n";} if(!empty($title->deathplace) || isset($deathcounty)){echo'
Died in ';} if(!empty($title->deathplace)){ if(mysql_num_rows($dtcheck) > 0){ echo"$title->deathplace"; } else{ echo"$title->deathplace"; } } if(!empty($title->deathplace) && isset($deathcounty)){echo', ';} if(isset($deathcounty)){echo"$deathcounty\n";} echo"
More about $title->name

"; if(!empty($title->link) || !empty($title->link2) || !empty($title->link3) || !empty($title->link4) || !empty($title->link5)){ echo"

Links:
\n"; if(!empty($title->link)){ if(strpos($title->link, 'showPlace')){echo"internal link";} else{echo" $title->link";} echo' '; if(!empty($title->comment)){echo"$title->comment\n";} echo'
'; } if(!empty($title->link2)){echo""; if(strpos($title->link2, 'showPlace')){echo"internal link";} else{echo" $title->link2";} echo' '; if(!empty($title->comment2)){echo"$title->comment2\n";} echo'
'; } if(!empty($title->link3)){echo""; if(strpos($title->link3, 'showPlace')){echo"internal link";} else{echo" $title->link3";} echo' '; if(!empty($title->comment3)){echo"$title->comment3\n";} echo'
'; } if(!empty($title->link4)){echo""; if(strpos($title->link4, 'showPlace')){echo"internal link";} else{echo" $title->link4";} echo' '; if(!empty($title->comment4)){echo"$title->comment4\n";} echo'
'; } if(!empty($title->link5)){echo""; if(strpos($title->link5, 'showPlace')){echo"internal link";} else{echo" $title->link5";} echo' '; if(!empty($title->comment5)){echo"$title->comment5\n";} } echo'

'; } ?>

More famous Britons here