Hi
i have a table

day     position
1         1
1         2
1         3
1         4
2         1
2         2
2         3   
2         4
3         1 
3         2
3         3
3         4
4         1
4         2
4         3
4         4

how i can order my day the same way as the figure below
many thanks

Member Avatar for diafol

I think we've already answered this for you once in a previous thread.

... ORDER BY `day`, `position`

//EDIT
Yes here it is:

https://www.daniweb.com/web-development/php/threads/490986/order-by-more-fields

I forgot that I wasn't going to reply to this anymore. Oh well, you're getting the same response as you did last time you asked. Ok, over and out.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.