Count and Group by

[TEENFRONT]

Hi,

 

Cut down code

SELECT count(number) FROM table GROUP BY title

echo $title .'<br>'. $number;

 

That outputs

 

Title1
5

Title2
9

Title3
2

 

But what do i do if i wanted to retain and loop through the "$number" actual values, not JUST count the total? I still need access to what "$number" is while looping. But as GROUP BY returns one result.. im stuck.

 

Ideally i want this as the resulting output

 

title1 // grouped title
3   // total number of $numbers per grouped title
1234
12345
123456  // The actual values of $number totalling to the above grouped number

title2 // grouped title
2   // total number of $numbers
1234
123456  // The actual values of $number totalling to the above grouped number

[BlueSkyIS]

i would skip the group by, pull all records sorted by title and load those into an array. then you can use count() on each title array to see how many there are, while also being able to loop over the titles, printing each one.