Multiple SELECT statements in PHP

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kdidymus
Forum Contributor
Posts: 196
Joined: Tue May 13, 2008 3:37 am

Multiple SELECT statements in PHP

Post by kdidymus »

Folks.

I have an issue. I'll try my best to explain it.

At the moment, I create a row in my database which includes sibling and siblingurn. The tuple named sibling contains the full name of a sibling and the tuple named siblingurn contains their unique reference number (URN) which is displayed as a hyperlink in the PHP code for clicking on.

I want to save myself time and space by using the siblingurn ONLY to download and display the name.

I run a

Code: Select all

SELECT * FROM tree WHERE urn='$urn'
query to download ALL of the info for a selected individual.

How do I then go about downloading the names of siblings from THEIR record. I guess the first one would be

Code: Select all

SELECT surname, forename, middlenames FROM tree WHERE urn='$siblingurn'
but when I tried this it started an endless loop!

Hope I made my problem clear. I guess to illustrate it, go to my family tree site (http://www.didymus.org.uk) and click on an individual. All of their parents, siblings, spouses and children's names are currently manually entered into the database. What I WANT to do is just download details of each relation from their URN.

Thanks in advance.

KD.
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Re: Multiple SELECT statements in PHP

Post by Kieran Huggins »

sounds like what you really want is a JOIN table:

Code: Select all

users
==========
id
name
birthday
etc
 
 
users_siblings
==========
user_id
sibling_id
(edit: my previous query was out to lunch, it had the soup)

get the user:

Code: Select all

SELECT u.* FROM users u WHERE u.id = $user_id;
grab the siblings:

Code: Select all

SELECT u.* FROM users u LEFT JOIN users_siblings us ON (us.user_id=u.id OR us.sibling_id=u.id) WHERE (us.user_id=$user_id OR us.sibling_id=$user_id)
*untested
kdidymus
Forum Contributor
Posts: 196
Joined: Tue May 13, 2008 3:37 am

Re: Multiple SELECT statements in PHP

Post by kdidymus »

Kieran.

Thank you. But reading your post it would appear I would need to create an entirely new table to store the siblings for my tree.

Here is the code for the page that displays the details of my ancestors. The code can be see in action at http://www.didymus.org.uk/display.php?urn=5831896

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);
  $urn = mysql_real_escape_string($_GET['urn']); 
  //urn passed by hyperlink
  $query = "SELECT * FROM tree WHERE urn='$urn'";
  $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'>";
  $urn = ucfirst($urn);
  while($row = mysql_fetch_assoc($result))
  {
     extract($row);
  echo "<p align='center'><font face='Arial' size='3'><b>$surname, $forename $middlenames ($yearofbirth)</font></b>&nbsp;<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>$urn</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>
        <tr $rowcl><td $nw><$text><b>MOTHER:</font></b></td><td><a href='$link$motherurn'><$hltext>$mother</a>
</font></td>\n</tr>
        <tr $rowht><td $nw><$text><b>FATHER:</font></b></td><td><a href='$link$fatherurn'><$hltext>$father</a></font></td>\n</tr>
        <tr $rowcl><td $nw><$text><b>SIBLINGS:</font></b></td><td><a href='$link$sibling1urn'><$hltext>$sibling1</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling2urn'><$hltext>$sibling2</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling3urn'><$hltext>$sibling3</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling4urn'><$hltext>$sibling4</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling5urn'><$hltext>$sibling5</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling6urn'><$hltext>$sibling6</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling7urn'><$hltext>$sibling7</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling8urn'><$hltext>$sibling8</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling9urn'><$hltext>$sibling9</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling10urn'><$hltext>$sibling10</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling11urn'><$hltext>$sibling11</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling12urn'><$hltext>$sibling12</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling13urn'><$hltext>$sibling13</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling14urn'><$hltext>$sibling14</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling15urn'><$hltext>$sibling15</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$sibling16urn'><$hltext>$sibling16</a></font></td>\n</tr>
        <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><a href='$link$spouse1urn'><$hltext>$spouse1</a></font></td>\n</tr>
        <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><a href='$link$spouse1child1urn'><$hltext>$spouse1child1</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child2urn'><$hltext>$spouse1child2</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child3urn'><$hltext>$spouse1child3</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child4urn'><$hltext>$spouse1child4</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child5urn'><$hltext>$spouse1child5</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child6urn'><$hltext>$spouse1child6</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child7urn'><$hltext>$spouse1child7</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child8urn'><$hltext>$spouse1child8</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child9urn'><$hltext>$spouse1child9</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child10urn'><$hltext>$spouse1child10</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child11urn'><$hltext>$spouse1child11</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child12urn'><$hltext>$spouse1child12</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child13urn'><$hltext>$spouse1child13</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child14urn'><$hltext>$spouse1child14</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child15urn'><$hltext>$spouse1child15</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse1child16urn'><$hltext>$spouse1child16</a></font></td>\n</tr>
        <tr $rowht><td $nw><$text><b>SPOUSE 2:</font></b></td><td><a href='$link$spouse2urn'><$hltext>$spouse2</a></font></td>\n</tr>
        <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><a href='$link$spouse2child1urn'><$hltext>$spouse2child1</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child2urn'><$hltext>$spouse2child2</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child3urn'><$hltext>$spouse2child3</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child4urn'><$hltext>$spouse2child4</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child5urn'><$hltext>$spouse2child5</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child6urn'><$hltext>$spouse2child6</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child7urn'><$hltext>$spouse2child7</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child8urn'><$hltext>$spouse2child8</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child9urn'><$hltext>$spouse2child9</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child10urn'><$hltext>$spouse2child10</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child11urn'><$hltext>$spouse2child11</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child12urn'><$hltext>$spouse2child12</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child13urn'><$hltext>$spouse2child13</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child14urn'><$hltext>$spouse2child14</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child15urn'><$hltext>$spouse2child15</a></font></td>\n</tr>
        <tr $rowcl><td></td><td><a href='$link$spouse2child16urn'><$hltext>$spouse2child16</a></font></td>\n</tr>
        <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>";}
?>
When the code gets to LINE 51, I'd like it to interrogate the MySQL and download the following tuples from the sibling's own record:

SURNAME
FORENAME
MIDDLENAMES
BLOODLINE

So if you followed the hyperlink above (http://www.didymus.org.uk/display.php?urn=5831896
what I want is for this code to get to line 51 and to then get details from URN 19123 (Edwin's first sibling) before printing her SURNAME, FORNAME and MIDDLENAMES as a hyperlink in the colour specified by the BLOODLINE tuple (either #000000 for non-bloodline or #FF0000 for bloodline).

I then want the code to continue displaying info downloaded from URN 5831896 until it reaches LINE 52 where it would get details from URN 1073A, print them and then continue on down.

At the moment I have ONE table (called "tree") and, if possible, I'd like to work on just that one table.

Is this possible and if so, how?!

Thanks in advance.

KD.
kdidymus
Forum Contributor
Posts: 196
Joined: Tue May 13, 2008 3:37 am

Re: Multiple SELECT statements in PHP

Post by kdidymus »

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 - IS MY CODE AS EFFICIENT AS IT COULD BE? Is there any way of compressing it or reducing its overall size?

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>&nbsp;<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.

For those of you who want to see the code in action, go to http://www.didymus.org.uk and have a look through my ancestors.

KD.
Post Reply