Posted by Marcin Dobrucki on 09/06/05 13:45

guitarromantic@gmail.com wrote:

> I have a 'staff' table with a column 'status', corresponding to a
> 'statuses' table with the appropriate titles (eg 1 | Editor in Chief).
> I want to display on the page the headings (the titles from statuses)
> along with all of the staff members with that status ID.
>
> I've attempted this using a query for each possible status, which I
> figure was pretty inefficient (plus it didn't work properly). The best
> I could do manually was to just display a list of staff and their
> statuses sorted in order of the title ranks.
>
> How can I do this efficiently?

How about (skipping the fetch from the db, assuming you have a result
already):

while ($row =& $res->fetchRow()) {
$staff[$row['title']][] = $row['name'];
}


This should create something like this:

array ( "Secretary" => array (0 => "Lolli Pop",
1 => "Jonsey Jones"
3 => "Bob Bored"),
"Editor in Chief" => array (0 => "Big Fish",
1 => "Jack Sardine"),
...);

Well, you catch the drift.

/Marcin

[Back to original message]