[SOLVED] Need help with SUM function

[StanLytle]

I'm trying to add the values of a column called 'Views" and output the result.  This is what I have, but it does not work.  What am I doing wrong?

 

$sql_query = "SELECT SUM(Views) AS TotalViews FROM Photos";

$result = mysql_query($sql_query);

$num = mysql_num_rows($result);

$TotalViews=number_format($num);

echo "$TotalViews";

 

Thanks,

Stan

 

[Barand]

You need to get the value from the resultset

 

$totalViews = mysql_result($result, 0, 'TotalViews')

[StanLytle]

That did the trick.  Thanks.

 

Stan