\r\n"; mail('jim.rolt@googlemail.com', $subject, $error, $headers); } include'dataedit/sql.php'; $title = "An A-Z of Famous British People"; $desc = "Information on 5000 Famous British People including quotes and birthdays"; if(isset($_GET['name'])){ $name = mysql_real_escape_string($_GET['name']); $sql = "SELECT id, name FROM famous WHERE name LIKE '%$name%' ORDER BY name"; $q = mysql_query($sql)or mailjim("q1", "$sql\n".mysql_error()); $text = "Results for your famous persons search on '$name':
\n"; $title = "search for '$name'"; $desc = "Famous British people: '$name'"; } elseif(isset($_GET['county'])){ $county = intval($_GET['county']); $sql = "SELECT SQL_CACHE id, name, CountyName, bcomregion FROM famous LEFT JOIN CountyDetails ON CountyDetails.RecordID = famous.birthcounty WHERE birthcounty = '$county' ORDER BY name "; $q = mysql_query($sql)or mailjim("q2", "$sql\n".mysql_error()); $cname = mysql_fetch_object($q); mysql_data_seek($q, 0); $text = "Famous people born in $cname->CountyName:
\n"; $title = "Famous people born in $cname->CountyName"; $desc = "Famous people born in $cname->CountyName, information on famous British people"; } $co = mysql_query("SELECT SQL_CACHE DISTINCT RecordID, CountyName, Country.Name AS cname, Country.ID AS cid, COUNT(*) AS num FROM CountyDetails INNER JOIN famous ON (famous.birthcounty = CountyDetails.RecordID OR famous.deathcounty = CountyDetails.RecordID) INNER JOIN Country ON Country.ID = CountyDetails.CountryID GROUP BY CountyName ORDER BY cid, CountyName")or mailjim("co", mysql_error()); if(isset($q) && mysql_num_rows($q) == 0){ $text = 'Sorry, we dont have any results for your search. Please try again'; } while($brit = mysql_fetch_object($q)){$picarray[] = array($brit->id, $brit->name);} shuffle($picarray); mysql_data_seek($q, 0); echo <<$title EOT; ?>

{$pic[1]}

EOT; break; } } /* if(!isset($_GET['search'])){ include'connect.php'; connect('', '', 'Famous britons'); } */ if(isset($county)){ include'yellowbcombox.php'; yellowbox($cname->CountyName,$cname->bcomregion); } ?>

Famous Britons | Name Search

'; while($row = mysql_fetch_object($q)){ if($count == $half){echo'';} echo"$row->name
\n"; $count ++; } } ?>

Click below to list famous people by Birthplace:

cname){ echo"$cou->cname: "; $check = $cou->cname; } echo"$cou->CountyName($cou->num) | \n"; } echo''; include'dailyfeature.php'; ?>