[SOLVED] Get All Values In Column

[majhate]

Hello,

 

Lets say I have a table with the fields: ID, Color, Value

So..

 

ID - Color - Value

 

1 - Blue - 3

2 - Orange - 1

3 - Black - 4

4 - Red - 2

 

How would I get the total of the values in one varible.

so $total would = 10

I've been trying loops, but I cannot get this to work. Any sugguestions?

 

Thanks!

[joecooper]

post up what you have tried, may help us a bit

[majhate]

This is what I have tried:

 

$query  = "SELECT choice_count FROM colors WHERE ID='$ID'";

$result = mysql_query($query);

 

while($rows = mysql_fetch_array($result, MYSQL_NUM))

{

 

$value = $rows[0];

echo $new . "<br />\n";

 

}

 

This will only display the values with a line break, I don't know how to add them up. I am not even sure if this would be the right way to do it.

[revraz]

Just use the mysql SUM function.

[majhate]

Could you elaborate on that please?

[revraz]

http://www.tizag.com/mysqlTutorial/mysqlsum.php

[GingerRobot]

As in:

 

<?php
$sql = mysql_query("SELECT SUM(value) FROM colors") or die(mysql_error());
$sum = mysql_result($sql,0);
echo $sum;
?>