i am making a while statement that is <% while (num < 6) %>
but i need to know how to get the feild out of the database that the while state ment is currently on.
There are feilds Card1, Card2, Card3, ect all the way to 10 in the database but i only need the first 6.
is there anyway i can go <%=rs("Card1")%> but instead of the 1 in Card1 can it get the value of num that the while state ment is currently on?
i tried to guess something like <%=rs("Card<%=num%>")%> but i cannot figure it out.