I have a database that has a bunch of words in it... It changes all the time though. I need to be able to select all the words from it and arrange it in a table. But I have NO clue how to make the table the way i want.

Table Design:
Word1 Word6
Word2 Word7
Word3 Word8
Word4 Word9
Word5

If anyone knows how to do something liekt hat it would be great!

Do you mean WORD1-9 are columns in the table? Is that you are looking for selecting values from all those columns and arrange it in one column of a different table?

_________________________
- Vijay G
Strive for Perfection

sorry.... I want to select Word1-9 from a column in a database, and arrange them in a ASP page, that looks like this:

ASP Page Table Design:
Word1 Word6
Word2 Word7
Word3 Word8
Word4 Word9
Word5

Use this logic.

Create connection and recordset objects.
1) open connection
2) contruct select statement as - "select wordcolumnname from tablename order by wordcolumnname"
3) open recordset using the above select statement.
4) Open Table tag, TR tag ad TD tag
5) Declare a counter
6) counter=0
7) Loop through recordset until EOF
    If (counter mod 5) = 0 then
        Response.write "</td>"
        If NOT recordsetobj.EOF then Response.write "<td>"
    End If
    Response.write recordsetobj("wordcolumnname") & "<BR>"
    Counter = counter + 1
    recordsetobj.movenext
8) End loop
9) If (counter mod 5) <> 0 then Response.write "</td>"
10)End TR and Table Tags

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

That really help! Thanks a lot!