Page 1 of 1

php sql order problem... breaking ties?

Posted: Sun Jul 08, 2007 11:04 am
by Citizen
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

Posted: Sun Jul 08, 2007 3:31 pm
by volka