Now that I've gained SOME of the experience I need to make a really good job of my family tree site, I've redesigned it.
Please take a look at http://www.didymus.org.uk/new/index.php?urn=11164
Not bad eh?!
Now try re-sizing your browser window. The iframe containing my details disappears.
Any idea why? I've tried everything.
This is the code for the two relevant pages:
INDEX.PHP
Code: Select all
<?php
/* Program: tree.php
* Desc: Family tree element.
*/
?>
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Didymus.org.uk | Family Tree</title>
<link rel="shortcut icon" href="/favicon.ico?" type="image/x-icon" />
</head>
<body>
<table border="0" style="border-collapse: collapse" width="100%" cellpadding="0" id="table1">
<tr>
<td colspan="3">
<p align="left"><img border="0" src="graphics/logo.gif" width="230" height="52"></td>
<td align="center" valign="bottom">
<img border="0" src="graphics/tree_on.gif"><img border="0" src="graphics/phot_off.gif"><a target="_top" href="contact/contact.php"><img border="0" src="graphics/con_off.gif"></a></td>
</tr>
<tr>
<td align="center" width="230" height="106" background="graphics/schbg.gif">
<br>
<br>
<form style="margin-bottom:0;" name="search" action="query.php" method="get" target="main">
<input type="text" name="T1" size="20" style="border: 1px solid #838383; padding: 0"><br>
<input type="image" src="graphics/gobutton.gif" value="Go!" name="B1"></form></td>
<td align="center" width="5" rowspan="7">
</td>
<td align="center" rowspan="7" colspan="2" style="border: 1px solid #000000; padding: 0" valign="top">
<iframe frameborder="0" name="main" width="100%" height="100%" src="display.php?urn=11164">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe></td>
</tr>
<tr>
<td align="center" width="230" height="5"></td>
</tr>
<tr>
<td align="center" width="230" height="106" background="graphics/a-zbg.gif">
<br>
<br>
<form style="margin-bottom:0; margin-top:0;" name="a-zfn" action="a-zfn.php" method="get" target="main">
<input type="image" src="graphics/fnbutton.gif" value="Go!" name="a-zfn"></form>
<form style="margin-bottom:0; margin-top:5;" name="a-zsn" action="a-zsn.php" method="get" target="main">
<input type="image" src="graphics/snbutton.gif" value="Go!" name="a-zsn"></form></td>
</tr>
<tr>
<td align="center" width="230" height="5"></td>
</tr>
<tr>
<td align="center" width="230" height="106" background="graphics/jmpbg.gif">
<br>
<br>
<form style="margin-bottom:0; margin-top:0;" name="jump" action="display.php" method="get" target="main">
<input type="text" name="urn" size="20" style="border:1px solid #838383; padding:0; "><br>
<input type="image" src="graphics/gobutton.gif" value="Go!" name="B1"></form></td>
</tr>
<tr>
<td align="center" width="230" height="5">
</td>
</tr>
<tr>
<td align="center" width="230" height="106" background="graphics/keybg.gif">
</td>
</tr>
</table>
<table border="0" style="border-collapse: collapse" width="100%" cellpadding="0" id="table2">
<tr>
<td>
<p align="center"><b><font size="2" face="Arial Narrow" color="#FF6600">
v5.0</font><font size="2" face="Arial Narrow" color="#838383">
| ©2008 Kris Didymus | All Rights Reserved</font></b></td>
</tr>
</table>
</body>
</html>Code: Select all
<?php
/* Program: display.php
* Desc: Displays all details of selected individual.
*/
// SET VARIABLES FOR DISPLAY
$link = "http://www.didymus.org.uk/new/display.php?urn=";
$text = "font face='Arial' size='1'";
$hltext = "font face='Arial' size='1' color='#000000'";
$nw = "nowrap";
// CONNECT TO MYSQL AND CHECK FOR ROW
include_once("../*******.inc.php");
$cxn = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
mysql_select_db($database);
$mainurn = mysql_real_escape_string($_GET['urn']);
$mainurn = ucfirst($mainurn);
//urn passed by hyperlink
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
// IF THE SPECIFIED ROW DOESN'T EXIST LOAD ERROR PAGE
if(mysql_num_rows($result)==0)
{
header("Location: urn404.php");
exit;
}
//IF THE ROW SPECIFIED EXISTS THEN
else {
//GO AHEAD AND DISPLAY RESULTS IN A TABLE
echo "
<html>
<head>
<meta http-equiv='Content-Language' content='en-gb'>
<meta http-equiv='Content-Type' content='text/html; charset=windows-1252'>
<title>INDIVIDUAL HERE</title>
</head>
<body topmargin='5' bottommargin='5'>
<table border='0' style='border-collapse: collapse' width='100%' cellpadding='0' id='table1'>
<tr>
<td style='border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px'>
<p align='center'>
<img border='0' src='graphics/indiv.gif'><br>";
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<font face='Arial' color='#FF0000' size='3' color='#$bloodline'><b>
$surname, $forename $middlenames ($yearofbirth) </b></font><img src='graphics/$relative.gif'></td>
</tr>
<tr>
<td>
<img border='0' src='graphics/parents.gif'><font face='Arial' size='3' color='#838383'>BIRTH,
PARENTS & SIBLINGS</font></td>
</tr>
<tr>
<td style='border: 1px solid #838383; padding: 0' bgcolor='#CCCCCC'><table border='0' style='border-collapse: collapse' cellpadding='0' id='table1'>
<tr>
<td align='right' width='175'><b><font face='Arial' size='1'>URN:</font></b></td>
<td width='5'>
<td><$text>$mainurn</font></td>
</tr>
<tr>
<td align='right'><b><font face='Arial' size='1'>DATE OF BIRTH:</font></b></td>
<td width='5'>
<td><$text>$dateofbirth</font></td>
</tr>
<tr>
<td align='right'><b><font face='Arial' size='1'>PLACE OF BIRTH:</font></b></td>
<td width='5'>
<td><$text>$placeofbirth</font></td>
</tr>
<tr>
<td align='right'><b><font face='Arial' size='1'>MOTHER:</font></b></td>
<td width='5'>
<td>";
//GET MOTHER DETAILS
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$motherurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a>
</font></td>\n</tr>";}
echo "<tr><td align='right'><b><font face='Arial' size='1'>FATHER:</font></b></td>
<td width='5'>
<td>";
//GET FATHER DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$fatherurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font></td>\n</tr>";}
echo "<tr>
<td align='right'><b><font face='Arial' size='1'>CHRISTENING / BAPTISM DATE:</font></b></td>
<td width='5'>
<td><$text>$christeningdate</font></td>
</tr>
<tr>
<td align='right'><b><font face='Arial' size='1'> CHRISTENING / BAPTISM PLACE:</font></b></td>
<td width='5'>
<td><$text>$christeningplace</font></td>
</tr>
<tr>
<td align='right' valign='top'><b><font face='Arial' size='1'>SIBLINGS:</font></b></td>
<td width='5'>
<td>";
//GET SIBLING 1 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling1urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 2 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling2urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 3 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling3urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 4 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling4urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 5 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling5urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 6 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling6urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 7 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling7urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 8 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling8urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 9 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling9urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 10 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling10urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 11 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling11urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 12 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling12urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 13 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling13urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 14 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling14urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 15 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling15urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SIBLING 16 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$sibling16urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
echo "</table></td>
</tr>
<tr>
<td>
<img border='0' src='graphics/spsekids.gif'><font face='Arial' size='3' color='#838383'>SPOUSE
1 & CHILDREN</font></td>
</tr>
<tr>
<td style='border: 1px solid #838383; padding: 0' bgcolor='#CCCCCC'><table border='0' style='border-collapse: collapse' cellpadding='0' id='table1'>
<tr>
<td align='right' width='175'><b><font face='Arial' size='1'>NAME:</font></b></td>
<td width='5'>
<td>";
//GET SPOUSE 1 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
echo "
<tr>
<td align='right'><b><font face='Arial' size='1'>MARRIAGE DATE:</font></b></td>
<td width='5'>
<td><$text>$spouse1marriagedate</font></td>
</tr>
<tr>
<td align='right'><b><font face='Arial' size='1'> MARRIAGE PLACE:</font></b></td>
<td width='5'>
<td><$text>$spouse1marriageplace</font></td>
</tr>
<tr>
<td align='right' valign='top'><b><font face='Arial' size='1'> CHILDREN:</font></b></td>
<td width='5'>
<td>";
//GET SPOUSE 1 CHILD 1 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child1urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 2 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child2urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 3 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child3urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 4 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child4urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 5 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child5urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 6 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child6urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 7 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child7urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 8 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child8urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 9 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child9urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 10 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child10urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 11 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child11urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 12 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child12urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 13 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child13urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 14 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child14urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 15 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child15urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 1 CHILD 16 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse1child16urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
echo "</table></td>
</tr>
<tr>
<td>
<img border='0' src='graphics/spsekids.gif'><font face='Arial' size='3' color='#838383'>SPOUSE
2 & CHILDREN</font></td>
</tr>
<tr>
<td style='border: 1px solid #838383; padding: 0' bgcolor='#CCCCCC'><table border='0' style='border-collapse: collapse' cellpadding='0' id='table1'>
<tr>
<td align='right' width='175'><b><font face='Arial' size='1'>NAME:</font></b></td>
<td width='5'>
<td>";
//GET SPOUSE 2 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
echo "<tr>
<td align='right'><b><font face='Arial' size='1'>MARRIAGE DATE:</font></b></td>
<td width='5'>
<td><$text>$spouse2marriagedate</font></td>
</tr>
<tr>
<td align='right'><b><font face='Arial' size='1'> MARRIAGE PLACE:</font></b></td>
<td width='5'>
<td><$text>$spouse2marriageplace</font></td>
</tr>
<tr>
<td align='right' valign='top'><b><font face='Arial' size='1'> CHILDREN:</font></b></td>
<td width='5'>
<td>";
//GET SPOUSE 2 CHILD 1 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child1urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 2 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child2urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 3 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child3urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 4 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child4urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 5 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child5urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 6 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child6urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 7 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child7urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 8 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child8urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 9 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child9urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 10 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child10urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 11 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child11urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 12 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child12urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 13 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child13urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 14 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child14urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 15 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child15urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
//GET SPOUSE 2 CHILD 16 DETAILS
$query = "SELECT * FROM tree WHERE urn='$mainurn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$query = "SELECT urn,surname,forename,middlenames,yearofbirth,bloodline FROM tree WHERE urn='$spouse2child16urn'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<a href='$link$urn'><$hltext><font color='#$bloodline'>$surname, $forename $middlenames ($yearofbirth)</a></font><br>\n";}
echo "</table></td>
</tr>
<tr>
<td>
<img border='0' src='graphics/death.gif'><font face='Arial' size='3' color='#838383'>DEATH</font></td>
</tr>
<tr>
<td style='border: 1px solid #838383; padding: 0' bgcolor='#CCCCCC'><table border='0' style='border-collapse: collapse' cellpadding='0' id='table1'>
<tr>
<td align='right' width='175'><b><font face='Arial' size='1'>DATE:</font></b></td>
<td width='5'>
<td><$text>$dateofdeath</font></td>
</tr>
<tr>
<td align='right'><b><font face='Arial' size='1'> PLACE:</font></b></td>
<td width='5'>
<td><$text>$placeofdeath</font></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<img border='0' src='graphics/notes.gif'><font face='Arial' size='3' color='#838383'>MISCELLANEOUS</font></td>
</tr>
<tr>
<td style='border: 1px solid #838383; padding: 0' bgcolor='#CCCCCC'><table border='0' style='border-collapse: collapse' cellpadding='0' id='table1'>
<tr>
<td align='right' width='175'><b><font face='Arial' size='1'> OCCUPATION:</font></b></td>
<td width='5'>
<td><$text>$occupation</font></td>
</tr>
<tr>
<td align='right' valign='top'><b><font face='Arial' size='1'>NOTES:</font></b></td>
<td width='5'>
<td><$text>$notes</font></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<img border='0' src='graphics/media.gif'><font face='Arial' size='3' color='#838383'>MEDIA
& CERTIFICATES</font></td>
</tr>
<tr>
<td style='border: 1px solid #838383; padding: 0' bgcolor='#CCCCCC'><a href='census.php?urn=$urn'><img border='0' src='$census'></a><a href='certs.php?urn=$urn'><img border='0' src='$certificates'></a><a href='photos.php?urn=$urn'><img border='0' src='$photographs'></a><a href='stories.php?urn=$urn'><img border='0' src='$scrapbook'></a><br><img src='graphics/blank.gif'></td>
</tr>";
}
echo "</table>\n";
echo "</body></html>";}
?>
</html>Thanks so very much in advance for any help you can give.
KD.