displaying database values question

[riotman]

here's what i'm trying to do...

i have three columns and i'm grabbing some names from a database. now depending on what the name that comes out of the database is i would like to place it in one of the 3 columns on the page. how would i accomplish this?

hopefully i've explained it clearly. thanks.

[Rob]

What criteria are you using? how many possibilities of 'name' are there?

I would prolly use 2 queries... a 'SELECT DISTICT name' followed by a standard select all.

If we had more info I could prolly steer you better however, it does sound like the table you have (in a normalised world) would be better split into two with name as a look up table.

[riotman]

I have about 13 names that i'm going to be pulling out. Right now they are just displayed in alphabetical order. I'm just having trouble figuring out how I could get a name that starts with O to be in the second column rather than the first, etc. I was thinking about setting up a variable to determine what heading to put it under.

A B C
1 2 3
6 4 8
5 7 12
10 11
13

see the above for an example of what i'm trying to do. i'm kinda new at this thing so sorry for the probably simple question.

[riotman]

i was actually able to figure this one out. thanks for the help though.

[Rob]

You're most welcome!