Multiple nested array from MySQL query

Question

I'm using foreach loops to access records in a nested array:

while ($row = mysql_fetch_assoc($result)){  
    $test_groups[$row['group_name']][] = $row['lab_test'];
  }

  foreach($test_groups as $group_name => $tests){
    echo "<tr><td><span class='test_group_name'>" . $group_name . "</span></td></tr>";
    foreach($tests as $test){
        echo "<tr><td>" . $test . "</td></tr>";
    }
    echo "<tr><td>&nbsp;</td></tr>";
}
echo '</table>';

This works OK. Now I need to add another level to the nested array, like:

$departments[$row['department_name']][$row['group_name']][] = $row['lab_test'];

Would this work and how should I adjust the for each loops above to cater for this?

pavel · Accepted Answer · 2015-03-17 08:39:21Z

1

Assign to array should be with [] at the end

$departments[$row['department_name']][$row['group_name']][] = $row['lab_test'];

Foreach loop will be:

foreach ($departments as $dep_name => $groups) {
    echo $dep_name;

    foreach ($groups as $group_name => $tests) {
        echo $group_name;

        foreach ($tests as $test) {
            echo $test;
        }
    }  
}

It's just with echoes, make there HTML as you need.

edited Mar 17, 2015 at 8:39

answered Mar 17, 2015 at 7:44

pavel

27.3k11 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple nested array from MySQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related