PHP Order by multiple columns

Question

I need an SQL query that orders a column by a ranking system, but if the ranks are the same, use the id as only a secondary, last resort order. Can anyone help me accomplish this? I have the system working with ORDER BY, but if rankings are the same, it screws up the system. I only need the primary, secondary ORDER BY code and not a whole query.

possible duplicate of PHP MySQL Order by Two Columns

John Carter
– John Carter

2011-11-06 07:56:42 +00:00
Commented Nov 6, 2011 at 7:56 — John Carter
– John Carter, Commented Nov 6, 2011 at 7:56

mu is too short · Accepted Answer · 2011-11-06 07:54:11Z

4

You just need to specify two conditions (separated by commas) in your ORDER BY clause:

ORDER BY ranking, id

answered Nov 6, 2011 at 7:54

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user981053 Over a year ago

I have tried that, but it is not giving me the correct entry from the database.

John Carter Over a year ago

@user981053 then you need to give us more information - edit the question with an example of the data and what you want.

user981053 Over a year ago

I figured it out. I was using (ORDER BY rank, id DESC) instead of using (ORDER BY rank DESC, id DESC). Thank you for the help.

Collectives™ on Stack Overflow

PHP Order by multiple columns

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related