Finding the sum of a column

[nextman]

i have a column in a mysql table, and id like to find the sum of the values inside it. any way to do this?

[nextman]

just to add to that, i have this code:

<?php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);

$query = ("SELECT SUM(site_views) FROM pm_videos");
$result = mysql_query($query);

echo "$result";
?>

 

but all i get back is "Resource id #2"

[nextman]

UPDATE: got it working. heres the code i used, its pretty simple - sums up a column and displays it:

 

<?php
$sqla= "SELECT SUM(column_name) AS Total FROM table_name"; 

$result = mysql_query($sqla) 
or die (mysql_error()); 
while ($myrow = mysql_fetch_array($result)) 
{ 

$total=$myrow["Total"];


echo 'The total is '.$total.'';
}
?>

[corbin]

Since you're you're using an aggregate function without a group by, you will not need a while loop.