[RESOLVED] split mysql results in 2 columns?

[iBuddy]

I have a mysql table that I am pulling data from for categories. So in the table there is id and name.
Examples:

1 general
2 music
3 sports
4 arts
5 auto
6 comedy
7 myspace
etc etc

What I am trying to do is split the categories in 2 columns. So basically find the # of categories in the database and display one half of the results on the left side column second half in the right side column?

So if there is 10 categories:
[column1] [column2]
(first 5 cats) (last 5 cats)

[bradgrafelman]

Have you tried searching the board? If so, give it another go - try keywords like 'display in columns' or something. This has been covered many, many times.

In fact, I thought Weedpacket even posted a snippet over in Code Critique...

EDIT: Woops, guess it wasn't in that forum... this is the thread I was referring to.

[iBuddy]

http://www.phpbuilder.com/board/showthread.php?t=10311631