Er. I'm getting myself confused now.
No. The row in the table is named
spouse1child1urn. My website is a family tree site. Each individual is assigned a Unique Reference Number (urn). So in the case of the URL I gave before, the PHP is using SELECT * on the row with my URN to extract the whole row. I then display each field in the PHP using $forename, $dateofbirth etc.
On the old version of the site (
http://www.didymus.org.uk/tree/display.php?urn=11164) I used a laborious long-hand method of checking for EACH child of an individual and if they existed, echoing their details. This method worked.
Now I want to automate this process. Set $i as a variable which steps from 2 to 16 (child 1 is dealt with differently as you'll see in the code below) and have a loop SELECT the relevant rows from the database and display various info ($fields) for each.
Here is a longer snippet of my code. I hope this helps somebdy to set me straight as I'm all out of ideas!....
Code: Select all
<td colspan='6' class='$spouseclass$tabb' $al><table border='0' cellspacing='0' cellpadding='0' id='spouse1'>
<tr>
<td class='heading' $ar>NAME:</td>
<td class='subspc'> </td>
<td ";
if ($spouse1urn == "404")
{echo "class='subinfo' $al>? </td>";}
else
{$query = "SELECT $fields FROM tree WHERE urn='$spouse1urn'";
$result = mysql_query($query)
or die ("Couldn't execute query");
while ($row = mysql_fetch_assoc($result))
{
extract($row);
if ($bloodline == "AA0000")
{
echo "class='subinfobl' $al><a href='$link$urn'>$forename $middlenames $surname";
if ($yearofbirth == "" OR $yearofbirth == "?" OR $yearofbirth == NULL)
{echo "</a> </td>";}
else
{echo " ($yearofbirth)</a> </td>";}
}
elseif ($bloodline != "AA0000")
{
echo "class='subinfo' $al><a href='$link$urn'>$forename $middlenames $surname";
if ($yearofbirth == "" OR $yearofbirth == "?" OR $yearofbirth == NULL)
{echo " </td>";}
else
{echo " ($yearofbirth) </td>";}}}}
echo " </tr>
<tr>
<td class='heading' $ar>DATE OF MARRIAGE:</td>
<td class='subspc'> </td>
<td class='subinfo'>";
if ($source7 == "")
{echo "$spouse1md";}
else
{echo "<a href='#' onclick=\"alert('$source7')\" title='$srcettl'>$spouse1md</a>";}
echo "</td>
</tr>
<tr>
<td class='heading' $ar>PLACE OF MARRIAGE:</td>
<td class='subspc'> </td>
<td class='subinfo'>";
if ($source8 == "")
{echo "$spouse1mp";}
else
{echo "<a href='#' onclick=\"alert('$source8')\" title='$srcettl'>$spouse1mp</a>";}
echo "</td>
</tr>
<tr>
<td class='heading' $ar>CHILDREN:</td>
<td class='subspc'> </td>
<td ";
$result = mysql_query($mainquery)
or die ("Couldn't execute query");
if ($spouse1child1urn == "" OR $spouse1child1urn == NULL)
{echo "class='subinfo'>None</td></tr>";}
else
{
$query = "SELECT $fields FROM tree WHERE urn='$spouse1child1urn'";
$result = mysql_query($query)
or die ("Couldn't execute query");
while($row = mysql_fetch_assoc($result))
{
extract($row);
if ($bloodline == "AA0000")
{
echo "class='subinfobl'>01: <a href='$link$urn'>$forename $middlenames $surname ($yearofbirth)</a></td></tr>";
}
elseif ($bloodline != "AA0000")
{echo "class='subinfo'>01: <a href='$link$urn'>$forename $middlenames $surname ($yearofbirth)</a></td></tr>";}
}}
$i=2;
while($i<=16)
{
if ($i<=9)
{$prefix = "0";}
elseif ($i>=10)
{$prefix = "";}
$childurn = "$start$sc1$i$end";
$query = "SELECT $fields FROM tree WHERE urn='\$spouse1child.$i.urn'";
$result = mysql_query($query)
or die ("Couldn't execute query");
while($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<tr>
<td> </td><td> </td><td ";
if ($bloodline == "AA0000")
{
echo "class='subinfobl'>$prefix$i$colon<a href='$link$urn'>$forename $middlenames $surname ($yearofbirth)</a></td></tr>";
}
elseif ($bloodline != "AA0000")
{
echo "class='subinfo'>$prefix$i$colon<a href='$link$urn'>$forename $middlenames $surname ($yearofbirth)</a></td></tr>";
}}
$i++;
}
echo "</table></td>";
TIA.
KD.