Creating a multi-dimensional array from query

Question

I am using the code below to create a multi-dimensional array from a query so that I can organize the results by category but it only gets me 2 columns (category, agency).

I am not sure how I can alter this so that I can get 4 columns (category, agency, description, website). Any help is greatly appreciated.

$categories = array();
while ($row = mysqli_fetch_array($result))
{
    $category = $row['category'];
    $categories[$category][] = $row['agency'];
}

<?php
    foreach ($categories as $category => $agencies)
    {
?>
    <h3><?php echo $category; ?></h3>
    <table class="chart">
<?php
    foreach ($agencies as $agency)
    {
?>
        <tr><td><?php echo $agency; ?></td></tr>
<?php
    }
?>
    </table>
<?php
    }
?>

brian_d · Accepted Answer · 2011-08-15 18:13:10Z

4

You could store the individual row results as an associative array:

$categories[$category][] = array(
      'agency' => $row['agency'], 
      'description' => $row['description'], 
      'website' => $row['website']
  );

answered Aug 15, 2011 at 18:13

brian_d

11.4k5 gold badges51 silver badges73 bronze badges

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

1 Comment

user895314 Over a year ago

Thanks, that is exactly what I was looking for. In my head this was far more complicated for some reason.

Collectives™ on Stack Overflow

Creating a multi-dimensional array from query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related