[SOLVED] SUM doesn't work

[ayok]

Hi,

I have this table

id          total

1           34

1           32

1           45

2           64

2           54

etc.

I want to sum the column total based on the id. So I made this mysql query.

<?php $sum = ("SELECT SUM(total),id FROM list GROUP BY id") or DIE(mysql_error());
$total = mysql_fetch_array($sum);

echo $total['sum(total)'];

But I've got blank result.

 

Could anybody tell me what's wrong?

 

Thank you

ayok

[fataqui]

$total['sum(total)'] is not equal to $total['SUM(total)']

 

keys are CASE Sensitive

[ayok]

Thank you. I've changed sum with SUM. But it still doesn't work.

 

ayok

[fenway]

Use a column alias.