[dmrgraphics]

This is for a schedule of people serving on a particular day. Just to pick a day I will choose Oct 4. I have a table called 'Oct 4' that has two fields 'department' and 'name'. There are like 12 different departments and each has at least 2 names of people that are serving in that department on any particular day.

The simple way to do this would be to just display department & name for each record, sort it by the department name, and list them down the page. However if there is multiple people serving in one department I only want to show the department heading once, then the names. I don't really need to get the department headings from the database, those can just be on the page itself.

The code below is what I am using for one section of this 'Childrens Ministry'. It works, except it is only showing one result under one heading. If I put this inside a repeat region, it will repeat the whole entire list of headings, including the next record in the list.

Code:

<div align="center"><strong>CHILDREN</strong><br />
Nursery: <br />
<?php

if($row_Recordset1['department'] == 'Nursery') {

echo $row_Recordset1['names']."</p>";

}?>
<br />
Baby Ministers:<br />
<?php

if($row_Recordset1['department'] == 'Baby Minister') {

echo $row_Recordset1['names']."</p>";

}?>
<br />
Pre Wee Church<br />
<?php

if($row_Recordset1['department'] == 'Pre Wee Church') {

echo $row_Recordset1['names']."</p>";

}?>
<br />
Wee Church<br />
<?php

if($row_Recordset1['department'] == 'Wee Church') {

echo $row_Recordset1['names']."</p>";

}?>
<br />
Childrens Church<br />
<?php

if($row_Recordset1['department'] == 'Childrens Church') {

echo $row_Recordset1['names']."</p>";

}?>
</div>

It seems like it should work but it isn't.

[wirehopper]

PHP Code:

Childrens Church<br />

<?php



if($row_Recordset1['department'] == 'Childrens Church') {



echo $row_Recordset1['names']."</p>";



}?>

... can be written more compactly like so:

PHP Code:

echo '<p><strong>'.$row_Recordset1['department'].'</strong><br />'.$row_Recordset1['names']."</p>"; 

You could put it in a loop like so:

PHP Code:

while ($row_Recordset1=mysql_fetch_array($rResult))

  echo '<p><strong>'.$row_Recordset1['department'].'</strong><br />'.$row_Recordset1['names']."</p>"; 

[carters-site]

wire got it

[Jcbones]

With Wirehopper's code, it will show the Department, and the name for every database entry. But, you want it to show the department only once, and then the names for that department, correct?

if so: (UNTESTED, but should work)

PHP Code:

while ($row_Recordset1=mysql_fetch_array($rResult)) {
    $storage[$row_Recordset1['department']][$row_Recordset1['names']];
    }
    
foreach($storage as $dept => $name) {
    echo '<p><strong>' . $dept . '</strong></p>';
    foreach($name as $person => $empty) {
        echo '<p>' . $person . '</p>';
    }
} 

[wirehopper]

Or:

PHP Code:

$storage[$row_Recordset1['department']][]=$row_Recordset1['names']; 

If this approach is used, the GROUP BY or ORDER BY on the query should include department.