GROUP BY can and can't

[tito]

Hello, I have a table with 32 teams in 8 groups of 4. I am trying to display them all under their group but I keep on getting a return of 1 team per group instead of 4. When I did an echo, it did show 8 rows. I am using php 4.32.

Are there any limits with what you can do with the GROUP BY clause?

When I remove the Group By, then it shows 32

     	$currentteams = $DB_site->query("
		SELECT * 
        FROM " . TABLE_PREFIX . "cclpinternational_teams
        WHERE disabled=1 AND name!='divadmin' AND division='$thedivision' 
        GROUP BY  groupname
        ORDER BY  groupname, name 

    ");  
	$rrows = $DB_site->num_rows($currentteams);

echo $rrows;

// the echo displays "8" for 8 groups, but I have 32 teams 

What i'd like to have:

GROUP A
1
2
3
4
GROUP B
5
6
7
8
GROUP C
9
10
11
12

etc...

[Roger_Ramjet]

You misunderstand the nature and function of the GROUP BY clause.

You do not want or need it here since you are want to output all rows, but in a specific order

 $currentteams = $DB_site->query("
        SELECT *
        FROM " . TABLE_PREFIX . "cclpinternational_teams
        WHERE disabled=1 AND name!='divadmin' AND division='$thedivision'
        ORDER BY  groupname, name

    ");   

Is all you need to get the data in the order you want. The presentation of that data with group heading etc is something you do in your php code.