ORDER BY second option ?

[Floodboy]

Hi I'm just wondering how to "order by" a second option if I order by "this, that " only return "this" ordered but if there are 2 elements with the same value inside "this" then mysql order those values by "id" and I want, that if there are 2 elements with same value inside "this" then order the values by "that" instead of "id"

---

|id| this |that|

How can I do that ???
😕

[cgraz]

This should work for you

SELECT * FROM your_table ORDER BY field1, field2

Cgraz

[Floodboy]

no, that code is what I was using and it just order the first field but not the second and if 2 elements are equal inside the field1 takes the "id" to order the results instead of take the field2

thanks anyway

[sijis]

i guess you could be more explicit if you want it ASC or DESC in the query.

taking Cgraz's example:

SELECT * FROM your_table ORDER BY field1, field2 ASC

or

SELECT * FROM your_table ORDER BY field1, field2 DESC

By default I think its ASC, but I could be wrong.

[laserlight]

Yeah, it should be ASC by default.

[rcmehta_14]

Can you please specifiy the fields values that you want to sort by? So that we can trace the problem. Otherwise I think cgraz's solution is right.

[Floodboy]

thanks all you people but, i fixed the problem 😃 this was the correct way

mysql_query("SELECT * FROM pilotroster ORDER BY hours DESC, mins DESC")

thanks all 😃