$query="SELECT * FROM figures WHERE year='$year'"; $result=mysql_query($query); $row=mysql_fetch_array($result); $jen_year_total=""; for($i=1; $i<=12; $i++) { $jen_year_total += $row["jen_$i"]; //echo "$row[jen_".$i."]"; echo $row["jen_$i"]; }