Help With Array Total

[mj99]

With this query

$query12 = "SELECT * FROM value LEFT JOIN horsevalue ON horsevalue.value_id = value.id WHERE horsevalue.horse_id = $horse_id AND horsevalue.value_id = ".$row['id']." GROUP BY value";
$result12 = mysql_query($query12) or die(mysql_error());
while($row12 = mysql_fetch_array($result12)){

$total = $row12['value'];

echo $total;

}

I get this result

10000000003005002005005003004008008001000200400500200100010002000

But what I want is

10,700

which would be the total of all the numbers in the array.

What am I doing wrong? I guess the whole query is just wrong.

[halojoy]

//

$total = 0; // the var to use for sum
while($row12 = mysql_fetch_array($result12)){

echo $row12['value'].'<br>'; // echo each value
$total += $row12['value'];   // total adds value ( += ) to itself

}

echo '<hr>'; // echo line
echo $total; // echo total sum

//

[laserlight]

The query is not wrong, but you do not need a loop. You should be able to calculate the total from the query, e.g.,

$query = "SELECT SUM(DISTINCT value) FROM value
          LEFT JOIN horsevalue ON horsevalue.value_id = value.id
          WHERE horsevalue.horse_id = $horse_id AND horsevalue.value_id = " . $row['id'];
$result = mysql_query($query);
$total = mysql_result($result, 0);