There are $number records in the Genealogical Database:
| Last Name |
First Name |
Middle Name |
State |
Birthday |
Birth Place |
Father |
Mother |
Full Name |
";
for($i=0; $i<$number; $i++) {
$id = mysql_result($result, $i, "id");
$l_name = mysql_result($result, $i, "l_name");
$f_name = mysql_result($result, $i, "f_name");
$m_name = mysql_result($result, $i, "m_name");
$state = mysql_result($result,$i,"state");
$birthday = mysql_result($result,$i,"birthday");
$birthplace = mysql_result($result,$i,"birthplace");
$father = mysql_result($result,$i,"father");
$mother = mysql_result($result,$i,"mother");
$fullname = mysql_result($result,$i,"fullname");
/* print even-numbered rows with a grey background,
odd-numbered with a white background */
if ($i%2 == 0) {
print "";
} else {
print "
";
}
print "| $l_name |
$f_name |
$m_name |
$state |
$birthday |
$birthplace |
$l_name |
$mother |
$fullname |
";
}
print "
";
// Close the database connection
mysql_close();
?>
Return to Main Menu