Okay. I've finally managed to solve this. The code below works BRILLIANTLY in that it continuously retrieves details from the MySQL database to populate the fields.
My only question is, although it works after many days of learning, experimenting, changing and testing -
Code: Select all
<?php
/* Program: display.php
* Desc: Displays all details of selected individual.
*/
// SET VARIABLES FOR DISPLAY
$link = "http://www.didymus.org.uk/display.php?urn=";
$rowht = "valign='top'";
$rowcl = "bgcolor='#CCFFCC' valign='top'";
$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><title>Individual Biographical Information</title></head>
<body topmargin='0' leftmargin='0' rightmargin='0' bottommargin='0'>";
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<p align='center'><font face='Arial' size='3'><b>$surname, $forename $middlenames ($yearofbirth)</font></b> <img src='tree/graphics/$relative.gif'><br><img src='tree/graphics/bio_tit.gif'>";
echo "<table cellspacing='0' width='450' align='center'>";
echo "<tr><td colspan='3'><hr /></td></tr>";
echo "<tr><td colspan='3' align='center'><a href='census.php?urn=$urn'><img border='0' src='$census'></a><a href='certs.php?urn=$urn'><img border='0' src='$certificates'></a><img border='0' src='tree/graphics/bio_off.gif'><a href='photos.php?urn=$urn'><img border='0' src='$photographs'></a><a href='stories.php?urn=$urn'><img border='0' src='$scrapbook'></a></td></tr>";echo "<tr><td colspan='3'><hr /></td></tr>";
echo " <tr>\n
<td $rowht $nw><$text><b>URN:</font></b></td><td><$text>$mainurn</font></td>\n
<tr $rowcl><td $nw><$text><b>SURNAME:</font></b></td><td><$text>$surname</font></td>\n</tr>
<tr $rowht><td $nw><$text><b>FORENAME(S):</font></b></td><td><$text>$forename $middlenames</font></td>\n</tr>
<tr $rowcl><td $nw><$text><b>DATE OF BIRTH:</font></b></td><td><$text>$dateofbirth</font></td>\n</tr>
<tr $rowht><td $nw><$text><b>PLACE OF BIRTH:</font></b></td><td><$text>$placeofbirth</font></td>\n</tr>";
echo "<tr $rowcl><td $nw><$text><b>MOTHER:</font></b></td><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 $rowht><td $nw><$text><b>FATHER:</font></b></td><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 $rowcl><td $nw><$text><b>SIBLINGS:</font></b></td><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 " <tr $rowht><td $nw><$text><b>CHRISTENING DATE:</font></b></td><td><$text>$christeningdate</font></td>\n</tr>
<tr $rowcl><td $nw><$text><b>CHRISTENING PLACE:</font></b></td><td><$text>$christeningplace</font></td>\n</tr>
<tr $rowht><td $nw><$text><b>SPOUSE 1:</font></b></td><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 $rowcl><td $nw><$text><b>MARRIAGE DATE:</font></b></td><td><$text>$spouse1marriagedate</font></td>\n</tr>
<tr $rowht><td $nw><$text><b>MARRIAGE PLACE:</font></b></td><td><$text>$spouse1marriageplace</font></td>\n</tr>
<tr $rowcl><td $nw><$text><b>CHILDREN:</font></b></td><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 " <tr $rowht><td $nw><$text><b>SPOUSE 2:</font></b></td><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 $rowcl><td $nw><$text><b>MARRIAGE DATE:</font></b></td><td><$text>$spouse2marriagedate</font></td>\n</tr>
<tr $rowht><td $nw><$text><b>MARRIAGE PLACE:</font></b></td><td><$text>$spouse2marriageplace</font></td>\n</tr>
<tr $rowcl><td $nw><$text><b>CHILDREN:</font></b></td><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 " <tr $rowht><td $nw><$text><b>OCCUPATION:</font></b></td><td><$text>$occupation</font></td>\n</tr>
<tr $rowcl><td $nw><$text><b>DATE OF DEATH:</font></b></td><td><$text>$dateofdeath</font></td>\n</tr>
<tr $rowht><td $nw><$text><b>PLACE OF DEATH:</font></b></td><td><$text>$placeofdeath</font></td>\n</tr>
<tr $rowcl><td $nw><$text><b>NOTES:</font></b></td><td><$text>$notes</font></td>\n</tr>
</tr>\n";
}
echo "</table>\n";
echo "</body></html>";}
?>
Thank you to those who tried to help with this. Sadly it was nigh-on impossible to explain EXACTLY what I needed my code to do.
and have a look through my ancestors.
KD.