how to devide into two column?

[salman1]

hi all,

 

in a mysql database table a field have 23 records, it can be increase or decrease. after query all r shows in a column. but i want to show them into two column. how its possible and how to code it? plz if any 1 help me it will be glad.

 

example:

my result:

number

1

2

3

4

5

6

7

 

expecting result:

number  number

1            4

2            5

3            6

                7

 

 

salman