Page 1 of 1

Disappearing iframe!

Posted: Sat Jul 12, 2008 9:14 am
by kdidymus
A strange one this.

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?! :wink:

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">
            &nbsp;</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">
            &nbsp;</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>
DISPLAY.PHP (which loads in to the iframe of INDEX.PHP)

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)&nbsp;</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'>&nbsp;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'>&nbsp;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'>&nbsp;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'>&nbsp;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'>&nbsp;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'>&nbsp;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'>&nbsp;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>
I'm really stuck with this. I guess I could ignore this problem but I'm too much of a perfectionist!

Thanks so very much in advance for any help you can give.

KD.

Re: Disappearing iframe!

Posted: Sat Jul 12, 2008 10:30 am
by kdidymus
Hmm. Seem to have solved this by swapping the tables around.

Thanks anyway.

KD.