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