\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'; ?>
\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':
cname){
echo"$cou->cname: ";
$check = $cou->cname;
}
echo"$cou->CountyName($cou->num) | \n";
}
echo'';
include'dailyfeature.php';
?>
\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 <<';
while($row = mysql_fetch_object($q)){
if($count == $half){echo' ';}
echo"$row->name
\n";
$count ++;
}
}
?>
Click below to list famous people by Birthplace: