CodeIgniter Forums
display title about grouped result in foreach - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: display title about grouped result in foreach (/showthread.php?tid=56331)

display title about grouped result in foreach - El Forum - 12-11-2012

[eluser]ppwalks[/eluser]
Hi all,

I need a bit of assistance, I have a foreach loop iterating through an array which is grouped by a field called level, what I need to do is add a h2 tag above each set of grouped results can anyone help with this please.

Here is my sql

Code:
$sql = "SELECT `id`, `title`, `level` from `toplevels`  GROUP BY level, title ORDER BY id ASC";

and my array is as follows

Code:
Array ( [0] => Array ( [id] => 1 [title] => Why Sewell [level] => 1 ) [1] => Array ( [id] => 2 [title] => About Sewell [level] => 1 ) [2] => Array ( [id] => 3 [title] => Services [level] => 1 ) [3] => Array ( [id] => 4 [title] => Careers [level] => 1 ) [4] => Array ( [id] => 5 [title] => Giving Back [level] => 1 ) [5] => Array ( [id] => 7 [title] => Paul's about us page 6 [level] => 2 ) [6] => Array ( [id] => 8 [title] => Hi all, another url problem [level] => 2 ) [7] => Array ( [id] => 9 [title] => a test [level] => 2 ) [8] => Array ( [id] => 14 [title] => Kierans About us page [level] => 2 ) [9] => Array ( [id] => 15 [title] => Article 1b [level] => 3 ) )

I need all the data with level 1 in one group and with a header and so on for each level assigned.

Thanks in advance Paul

display title about grouped result in foreach - El Forum - 12-11-2012

[eluser]Aken[/eluser]
You should loop your results and filter them into a new array, using the level as an array key.

Code:
$sorted = array();

foreach ($result as $row)
{
$sorted[$row['level']][] = $row;
}

print_r($sorted);


display title about grouped result in foreach - El Forum - 12-12-2012

[eluser]ppwalks[/eluser]
Thanks but not what I was looking for any suggestions

Want to display

Code:
<h2>About Us</h2>
...... All levels 1 stuff
<h2>Some more stuff</h2>
......All level 2 stuff

And so on...



display title about grouped result in foreach - El Forum - 12-13-2012

[eluser]ppwalks[/eluser]
anyone this is driving me nuts

display title about grouped result in foreach - El Forum - 12-13-2012

[eluser]CroNiX[/eluser]
Code:
$last_title = '';  //keep track of the last title used

foreach($your_array as $data)
{
  //compare to see if the current title is the same as the last one, if NOT print it
  if ($data['title'] !== $last_title)  
  {
    echo '<h2>' . $data['title'] . '</h2>';
  }
  //print the rest of the data
  echo '<div>' . $data['more_stuff'] . '</div>';

  //now set $last_title so you can check against it during the next loop
  $last_title = $data['title'];  
}