sorting table by index

[rotemblu]

I have a table with answered questions that looks like that:
1 answer 1
1 answer 2
1 answer 3
1 answer 4
.
.
.
2 answer 1
2 answer 2
2 answer 3
2 answer 4
.
.
ect

and I want it to transform it to a table like this:
answers 1 answers 2 answers 3 answers 4 ...
1 answer 1 answer 2 answer 3 answer 4 ...
2 answer 1 answer 2 answer 3 answer 4 ...

how do I do that?
thanks!!!

[flann]

select field
from table
order by field1, field2

[celon_php_master]

if u put the table structure i might be able to help u or otherwise email me to buddhikaperera@hotmail.com