adding rows

[herghost]

Hi all,

 

I am sure I knew how to do this 

 

Basically I want to pull the field followers which is an int for each row and add them together

$query = "SELECT followers FROM user_profile"; 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))

$i = 0;
{
$total = $row['followers'];
$a = $i + $total;
}

echo $a;

 

$a is returning zero though

 

Cheers

 

[wildteen88]

Your while loop is not constructed correctly. $i = 0; should be on the line before the while loop.

 

Also you could just let MySQL add up the followers using the SUM() mysql function

$query = "SELECT SUM(followers) AS total_followers FROM user_profile";

Then you can get the total using $row['total_followers']