4 columns retrieve data

Uncoder

hi,

i have any list of country in mysql database, how to list this data in 4 ( and more ) vertical html columns (div/table .... ) with name sort .
Example :

1.ALBANIA |9................|................|................. and more
2.............. |10..............|................|
3.............. |11..............|................|
4.............. |12..............|................|
5.............. |13..............|................|
6.............. |14..............|................|
7...............|15..............|................|
8...............|16..............|................|

Thanks

Uncoder

Any Help !! Idea ?

bradgrafelman

If you had 4 rows returned, are you wanting them to display like:

1		2		3		4

? What should it look like with 5 rows returned?

Uncoder

I have 60 rows in mysql database! now for display in div( html ) / 4 = 15 line to each columns. Now my mean for 5 and more for generate dynamic columns if myqsl rows > 60 .

Thanks

johanafm

Well, if you do go with your approach, you'd have to reorder the set to match how you create output. Hint: you create output row by row (as in, every cell in one row before starting on the next row) rather than column by column.

In your example above, you will in other words need to output Country 1, Countr 9, Country 17 etc, until the first row is done, and then you start on Country 2, Country 10 etc. Take your alphabetically ordered set, and reorder it according to this output order and you will have no problems.
Well, until you get 61 countries in the set instead of 60. Does the 61st country go in a new column? Or should the last column have an extra country. Or should the first column have an extra column - and also cause your entire set to be ordered differently, starting with country10 in the second column etc.

Uncoder

Any Code Example ?

johanafm

Ah, question time! You get to answer one of two sets of question for me then

Set 1:
What did you try?
What didn't work?

Set 2:
Why should I write the code for you?