herghost Posted May 26, 2011 Share Posted May 26, 2011 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 More sharing options...
wildteen88 Posted May 26, 2011 Share Posted May 26, 2011 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.