Lets say I want to order a mysql query by a particular column, but there may be lots of entries with the same values. I want one to come before the other if they are tied and one has more of a different column.
So instead of
Entry - Value - Value2
Entry 1 - 4 - 2
Entry 2 - 4 - 3
It comes up as
Entry 2 - 4 - 3
Entry 1 - 4 - 2
php sql order problem... breaking ties?
Moderator: General Moderators
SELECT ... ORBER BY x,y
see http://www.w3schools.com/sql/sql_orderby.asp
see http://www.w3schools.com/sql/sql_orderby.asp