$query="SELECT * FROM figures"; $result=mysql_query($query); $row=mysql_fetch_array($result); $jen_year_total=0; while($row=mysql_fetch_array($result)) { for ($i = 1; $i <= 12; $i++) { $jen_year_total += $row["blah_$i"]; echo $row["blah_$i"]; } } echo $jen_year_total;