php - simple sql order by position -

okay have been putting off because has been partially working, need it.

i want output:

id position 1       1        2       2         15      3          16      4           

i thought this^ it. getting whole pages table.

select *  pages  order position asc  id  link_id     menu_name     position     content     visible 1     1         new article       1     first picture ,   article     1 2     1         edit articles     2     delete articles/edit 333 

the * in query means you'll select every colomn, use columnames want retrieve.

example:

select id, position pages order position 

that's ;)