Printing nested WHILE loops?

[sunshine66]

Hi,
I'm trying to figure out how to combine while loops to get the following results:

Employee Name | Marital Status | List Dependents
Employee A Family Dependent A, DependentB
Employee B Single n/a

I'm able to get the employee list to print, but I don't know how to list the dependents. Right now, all I do is show a link to either ADD or VIEW dependents, i.e.
Employee Name | Marital Status | List Dependents
Employee A Family ADD or VIEW

Here is the code:

/* assume code is here to query Db, and fetch results for employee */


while($line = mysql_fetch_array($result2))
{
        $EEid    = $line["EmployeeID"];
        $last     = $line["EmployeeLast"];
        $first     = $line["EmployeeFirst"];	
        $status  = $line["MaritalStatus"];	

    if( $c == 0 ){
            $color = "dddddd";
            $c = 1;
    }else{
            $color = "white";
            $c = 0;
    }

//If employee is single
if ($status=="Single")
{	
$tableinfo .= "<tr bgcolor=$color>
<td nowrap>$last, $first</td>
<td nowrap>$status</td>
 <td nowrap class=\"small\">n/a</td><td nowrap class=\"small\">n/a</td>
</tr>\n";
}

//If employee = family 
if ($status=="Family")	
           {
	$tableinfo .= "<tr bgcolor=$color>
	<td nowrap>$last, $first</td>
	<td nowrap>$status</td>
	<td align=\"center\"><A HREF=\"dependents_add.php?id=$EEid\">ADD</A> or <A HREF=\"dependents.php?id=$EEid\">View</A></td></td>
	</tr>\n";
}

print "<table cellpadding=1 cellspacing=1 width=100% border=\"0\" bordercolor=\"#cccccc\">
       <tr>
	  <th align=\"left\" valign=\"bottom\">Name</th>
	  <th nowrap align=\"left\" valign=\"bottom\">Marital Status</th>
	  <th valign=\"bottom\">Dependents</th>
          </tr>";
print "$tableinfo";
print "</table>";
print "<br>";
print "<center><table>";

I understand how to create the 2nd While Loop to get the list of dependents, but how would I do the Print statements?

I'm at a loss so help is appreciated.

[devinemke]

where are the dependents stored? in a separate table? if so you could something like this (i'm just guessing here at your data structure and naming conventions so tweak as necessary):

while ($row = mysql_fetch_array($result2))
{
	$employees[$row['EmployeeID']] = $row;
	if ($row['status'] == 'Family') {$employees_married[] = $row['EmployeeID'];}
}

$result = mysql_query('SELECT Employee_ID, Name FROM dependents WHERE Employee_ID IN(' . implode(',', $employees_married) . ')');
while ($row = mysql_fetch_assoc($result))
{
	$employees[$row['EmployeeID']]['dependents'] = $row['name'];
}

echo '
<table border=1>
<tr>
<td>Name:</td>
<td>Marital Status:</td>
<td>Dependants:</td>
</tr>
';

foreach ($employees as $value)
{
	if (isset($value['dependents']))
	{
		$dependents = implode('<br>', $value['dependents']);		
	}
	else {$dependents = 'N/A';}

extract($value);

echo '
<tr>
<td>' . $first . ' ' . $last . '</td>
<td>' . $status . '</td>
<td>' . $dependent . '</td>
</tr>
';
}

echo '</table>';

[sunshine66]

Hi,
Had some trouble figuring out what I'm doing wrong, even with your code, so I changed my approach.
You seem so smart, so please check this post and see if you can help me....please?
REF: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10285077
This thread is marked as resolved because it answers my question about UNION syntax error, however, the last post in this discussion describes my new problem.

So does
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10285128
but instead of a table format, it's a SELECT list.