loop help

[lucashii]

I have a table with "brand" and "total"

Brand | Total

Coke | 30
Coke | 24
Pepsi | 12
Pepsi | 11

Output: Coke 54 Pepsi 23

I wish to create a loop which would output the total for the different brands. Need some guidance. any help would be appreciated Thanks~~

[bretticus]

instead of using PHP just use a SQL query:

$query = "SELECT Brand, SUM(Total) FROM table GROUP BY Brand";

[lucashii]

Thanks it work~ Using the sql statement as suggested i was able to echo out both the brand and total. Is it possible just to display out the total and not the brand as i have tried doing echo $row['total'] and it doesnt work. any help would be appreciated~thank~~

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
foreach ($row as $result){
echo $result;
}