Jump to content

adding rows


herghost

Recommended Posts

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

 

Link to comment
https://forums.phpfreaks.com/topic/237553-adding-rows/
Share on other sites

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']

Link to comment
https://forums.phpfreaks.com/topic/237553-adding-rows/#findComment-1220698
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.