View Full Version : Small Thing

01-13-2005, 12:50 AM
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.


01-13-2005, 02:03 AM
<%=rs("Card" & num)%>

01-13-2005, 04:34 AM
thx a ton glenn

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum