<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Infused.org Genealogy - Surname List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Language" content="EN-US">
<meta name="description" content="">
<meta name="author" content="Keith Morrison, keithm@infused.org">
<meta name="copyright" content="(c)2000-2003 Keith Morrison, Infused Solutions">
<meta name="robots" content="FOLLOW,INDEX">
<meta name="keywords" content="">
<link rel="stylesheet" href="styles2.css">
</head>
<body text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FFCC33" vlink="#FFCC33" alink="#FF9900" background="/images/dark_grey_lines.gif">
<?php include("small_header.html); ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" width="165">
<?php include("genealogy_menu.html); ?>
</td>
<td align="left" valign="top">
<?php
include("db.inc.php");
include("html.inc.php");
//Display list of surnames if one has not been selected
if (!$sn) {
$query = "SELECT surname, count(surname) AS number FROM gen_indiv GROUP BY surname";
$result = mysql_query($query);
open_table(array("width" => "100%", "border" => "0", "cellpadding" => "8", "cellspacing" => "0"));
open_row();
open_column(array("class" => "b9", "align" => "left", "valign" => "top"));
print "Unique Surnames in Database";
close_column();
open_column(array("class" => "b9", "align" => "right", "valign" => "top"));
print mysql_num_rows($result)." Surnames";
close_column();
close_row();
open_row();
open_column(array("class" => "n8", "colspan" => "2"));
print "<hr size=\"1\">";
close_column();
close_row();
open_row();
open_column(array("class" => "n8", "colspan" => "2"));
while ($row = mysql_fetch_array($result)) {
$letter = strtoupper(substr($row["surname"],0,1));
if ($alpha != $letter) {
$alpha = $letter;
print "</p>\n";
print "<p class=\"b8\">- ".$alpha." -</p>\n";
print "<p>\n";
} else { print ",\n"; }
print "<a href=\"".$_SERVER["PHP_SELF"]."?sn=".$row["surname"]."\">";
print $row["surname"];
print " (".$row["number"].")";
print "</a>";
}
close_column();
close_row();
close_table();
}
if ($sn) {
$query = "SELECT indkey, surname, givenname FROM gen_indiv WHERE surname = \"$sn\" ORDER BY givenname";
$result = mysql_query($query);
open_table(array("width" => "100%", "border" => "0", "cellpadding" => "8", "cellspacing" => "0"));
open_row();
open_column(array("class" => "b9", "align" => "left", "valign" => "top"));
print "<a href=\"".$_SERVER["PHP_SELF"]."\">Surnames</a> : ".$sn;
close_column();
open_column(array("class" => "b9", "align" => "right", "valign" => "top"));
print mysql_num_rows($result)." Individuals";
close_column();
close_row();
open_row();
open_column(array("class" => "n8", "colspan" => "2"));
print "<hr size=\"1\">";
close_column();
close_row();
open_row();
open_column(array("class" => "n8", "align" => "left", "colspan" => "2"));
open_table(array("border" => "0", "cellpadding" => "0", "cellspacing" => "0"));
open_row();
open_column(array("class" => "b8", "width" => "50")); print "View"; close_column();
open_column(array("class" => "b8", "width" => "275")); print "Name"; close_column();
open_column(array("class" => "b8", "width" => "150")); print "Birth"; close_column();
open_column(array("class" => "b8", "width" => "150")); print "Death"; close_column();
close_row();
while($row = mysql_fetch_array($result)) {
$indiv = $row["indkey"];
$query_birth = "SELECT date from gen_facts WHERE indfamkey = \"$indiv\" AND type = \"Birth\"";
$result_birth = mysql_query($query_birth);
$birth = mysql_fetch_array($result_birth);
$query_death = "SELECT date from gen_facts WHERE indfamkey = \"$indiv\" AND type = \"Death\"";
$result_death = mysql_query($query_death);
$death = mysql_fetch_array($result_death);
open_row();
open_column(array("class" => "n8"));
print "<a href=\"family.php?indiv=".$indiv."\">View</a>"; close_column();
open_column(array("class" => "n8")); print $row["surname"].", ".$row["givenname"]; close_column();
open_column(array("class" => "n8")); print ucwords(strtolower($birth["date"])); close_column();
open_column(array("class" => "n8")); print ucwords(strtolower($death["date"])); close_column();
close_row();
}
close_table();
}
?>
</td>
</tr>
<tr align="center" valign="top">
<td class="smallprint" colspan="2">
<?php include("small_footer.html); ?>
</td>
</tr>
</table>
</body>
</html>
© 1999-2003 Keith Morrison, Infused Solutions