[RESOLVED] This is easy, I think - mySQL

[NFClimber]

So here's what I've got. I'm generating some graphs, and I want to be able to select the number of rows from a table, and then return the number of rows with a specific value...for instance.

I've got this data:

John Group 1
Jesse Group 2
Frank Group 1
Jack Group 2
Fred Group 3
Jenn Group 1
Amy Group 1

So if I generate a pie chart with this data, I need the number of rows from Group 1, the number with Group 2, and the number with Group 3.

Without specifying specifically (group 1, group 2, etc.), how can I select this data? I'm just not sure what the best way would be to do this. Thanks.

[Installer]

Assuming you have the group numbers in a separate column (e.g. column "group", row value "1"), this should work:

$query = "SELECT `group`, COUNT(`group`) AS ct " .
         "FROM test_01 " .
         "GROUP BY `group`";        

$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
    echo 'Group ' . $row['group'] . ' has ' . $row['ct'] . ' entries.<br />';
}

[NFClimber]

That worked great! I knew I had to use a group command somewhere, and I just completely forgot about the COUNT function. Long week...

Thanks again!