How to create array of groups and their users

[sarahaziz]

Hello guys
i want to create something like this image ,consider the fact that Group and users comes from 2 different tables but only one query.
I want to add them into one array.

[kovik]

So... what are you having difficulty with? Storing the users into an array, or displaying them into this format that you have given?

[sarahaziz]

Since i get all data from only one query the group is repeated with each record i want to add it once in the array and then add users of this group after it in the array.
How is that done?

[dlite922]

so if you have something like this:

 
John Doe    grpA 
Jane Smith  grpB
Helen Fake  grpA
Tom Record  grpA
Micky Mouse grpB
 
 

Just use an associative array with the group being the key and each name list will be another array

 
$data = array(); 
 
while($row = mysql_fetch_assoc($resource))
{
   $group = $row['group_name']; 
   $name = $row['person_name'];
 
   $data[$group][] = $name; 
 
}
 
 
 

That should do it.

Dan

[kovik]

That's quite graceful. I was going to suggest the direct echoing method when you order the items by group in the SQL and then output the group name whenever the group changes.

$result = mysql_query("select * from users order by group asc");
$current_group = null;
 
echo '<ul>';
 
while ($data = mysql_fetch_object($result)) {
    if ($current_group != $data->group) {
        $current_group = $data->group;
        echo "<li><strong>{$data->group}</strong></li>";
    }
 
    echo "<li>{$data->user}</li>"
}
 
echo '</ul>';