Displaying Parent/Child lists

[eluser]thunder uk[/eluser]
A slightly easier way to do it (assuming you do pull the staff and department info together and it's ordered by department) would be to set a flag as you loop through the record set.

eg

Code:

$current_department = "";

foreach($recordset as $row)
{
    if($current_department != $row['department']) // If the department has changed
    {
        $current_department = $row['department']; // Set the current flag to the new department
        echo("<b>" . $current_department . "</b>"); // and output the department header
    }

    // Output the staff details here

}

That way, the header row will only get output when the department changes. The above code would need to be fixed up a little obviously according to the fields in your select statement.