printing total from a group

[Anon]

Hi All

I have a table calling from a mysql table where I list all data under a certain id

SELECT * from $table Where id = '$id' GROUP BY id;

simple enough

will in this table I have a num keeping track of whatever

12 <- fisrt row
23
11

I want to add them up
no problem there
$total = $total + $row[num];

Now here is the problem

scine I'm grouping them it showing only one result the result from the number colum is showing 12 fisrt row (see above) if I remove group the last row has the right total but I cant print with group

blah | num | blah

some | 46 | thing

instead printing

blah | num | blah

some | 12 | thing

Hope you understand and if you do how can I print the total