[rcpilotp51]

I have 9 gif images (1,2,3,4,5,10,20,50,100).

i have a profile section on my website. At work a bunch of us play basketball. and i wanted to keep track of each persons wins.

Using asp and a access database where i could just add a field to their profile...I want to do the following

Say "joe" has 139 wins...instead of displaying 139 i want to display a combination if the 9 images above (each image is different colored basketballs- 1-4 are clusters of the same color, 5,10,20,50 and 100 are individual basketballs of different colors)

So then 139 would then display as

100,20,10,5,4 -adding up to 139

Does anyone know the algorithm fo doing something like this, or even an asp code snippet.

thanks
Keith

[GO4TF4CE]

heres a basic example of what I would do, I would normally use an array for the numbers, but I wanted to keep it simple, so you could see what is going on.

<%
set rs=server.createobject("ADODB.recordset")
rs.open "SELECT score from MyTable",conn

do while not rs.eof
tempscore=rs("score")

do while tempscore > 100
tempscore=tempscore - 100
response.write("<img src=""images/100.jpg>")
loop

do while tempscore > 50
tempscore=tempscore - 50
response.write("<img src=""images/50.jpg>")
loop

do while tempscore > 20
tempscore=tempscore - 20
response.write("<img src=""images/20.jpg>")
loop

do while tempscore > 10
tempscore=tempscore - 10
response.write("<img src=""images/10.jpg>")
loop

do while tempscore > 5
tempscore=tempscore 5
response.write("<img src=""images/5.jpg>")
loop

do while tempscore > 4
tempscore=tempscore - 4
response.write("<img src=""images/4.jpg>")
loop

do while tempscore > 3
tempscore=tempscore - 3
response.write("<img src=""images/3.jpg>")
loop

do while tempscore > 2
tempscore=tempscore - 2
response.write("<img src=""images/2.jpg>")
loop

do while tempscore > 1
tempscore=tempscore - 1
response.write("<img src=""images/1.jpg>")
loop

rs.movenext
loop

rs.close
set rs=nothing
%>

Hope this makes sense

[rcpilotp51]

thanks GO4TF4CE

thats what i ended up figuring out...haha...thanks for the post!

Rcpilotp51