[SOLVED] add up all the values in a column

[owner]

How would you add up all the values in a column in the mySQL database.

 

here is what I have.

 

 

So the value returned would be 115.

 

For the name of the column, it can be blah and the table is called red.

 

Thanks,

-Owner

[pocobueno1388]

<?php

$query = mysql_query("SELECT SUM(blah) as sum FROM table_name");
$row = mysql_fetch_assoc($query)or die(mysql_error());
echo $row['sum']; //will print out sum

?>

[owner]

thanks much!