<html>
<head>
<title>Search Results</title>
</head>
<body>
<?php
include("db.inc.php");
include("html.inc.php");
if ($gname OR $sname) {
if ($soundex == "yes") {
$query = "SELECT indkey, surname, givenname FROM gen_indiv WHERE soundex(surname)=soundex(\"$sname\") AND givenname LIKE \"%$gname%\" ORDER BY surname, givenname";
}
else {
$query = "SELECT indkey, surname, givenname FROM gen_indiv WHERE surname LIKE \"$sname%\" AND givenname LIKE \"%$gname%\" ORDER BY surname, givenname";
}
$result = mysql_query($query);
open_table(array("width" => "100%", "border" => "0", "cellpadding" => "2", "cellspacing" => "8"));
open_row();
open_column(array("class" => "b9headrow", "align" => "left", "valign" => "top"));
print "Search Returned ".mysql_num_rows($result)." Individuals";
close_column();
close_row();
open_row();
open_column(array("class" => "n8", "align" => "left"));
open_table(array("border" => "0", "cellpadding" => "0", "cellspacing" => "0"));
open_row();
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."\">";
print $row["surname"].", ".$row["givenname"];
print "</a>";
close_column();
open_column(array("class" => "n8"));
if ($birth["date"]) { print ucwords(strtolower($birth["date"])); }
else { print " "; }
close_column();
open_column(array("class" => "n8"));
if ($death["date"]) { print ucwords(strtolower($death["date"])); }
else { print " "; }
close_column();
close_row();
}
close_table();
}
?>
</body>
</html>
© 1999-2003 Keith Morrison, Infused Solutions