Sum of values in php

[onlyican]

Hey
My brain is dead today, I had too much sleep last night, I hit 5 hours. (This is a lot to me)

Anyway

I have a Mysql Table
In that table I have a field called amount, which is a double
and a field called aff, which is a number not unique, but refers to the id_num of the affiliates

Anyway

I am running a query to find out who is owed money, and how much

This is wha I have so far

$query2 = "SELECT * FROM sales WHERE paid = 'n' GROUP BY aff";

The problem is this only gives me one value from the amount, it is not adding them up

I can run another query
$total_amount = "SELECT SUM(amount) FROM sales WHERE paid = 'n' AND aff = '".$row2["aff"]."'";

But is there a better way to do all this

I am thinking off the amount of queries that might run on one page

[sasa]

try
[code]$total_amount = "SELECT SUM(amount) FROM sales WHERE paid = 'n' GROUP BY aff";[/code]

[onlyican]

mm, simular to what I posted and did not want to use

Anyway I am using it, it works out best for the rest of the code
thanx