Array..måske? -> MERE

Jeg har 87 beregninger..

sql= "select distinctrow sum(s1) as sum_s1, "
sql= sql & "sum(s2) AS sum_s2, sum(s3) AS sum_s3, "
sql= sql & "sum(s4) AS sum_s4, sum(s5) AS sum_s5, "
osv ->

total1=rs ("sum_s1")
total2=rs ("sum_s2")
total3=rs ("sum_s3")
osv ->

1<img src="images/red.jpg" height="10" width="<%= (total1/count)*100 %>">
<%= formatnumber((total1/count)*100,1)  %>%<br>
2<img src="images/yellow.jpg" height="10" width="<%= (total2/count)*100 %>">
<%= formatnumber((total2/count)*100,1)  %>%<br>
3<img src="images/green.jpg" height="10" width="<%= (total3/count)*100 %>">
<%= formatnumber((total3/count)*100,1)  %>%<br>

osv ->

Men det kan da ik´passe at jeg skal skrive dem alle -> 87 ?

Kan jeg ikke anvende..et array måske ?

Jeg har i forvejen en tæller <%=i%> og et navnefelt <%=rs("ting")%>