php sql order problem... breaking ties?
Posted: Sun Jul 08, 2007 11:04 am
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
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