var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Order by+DESC and negative number
I have a little problem that I would be glad if someone could help me to solve.
I have a table with a number of players, in that table I have all players scores and game difference.
If I do a:" SELECT* FROM player ORDER BY points DESC, gamediff DESC"
name points goaldiff
playerA 10 15
PlayerB 8 10
PlayerC 6 -5
PlayerD 6 -4
This is wrong in ordinary mathematic because "-5" is less than "-4"
Can I do anything to overcome this problem?
Thanks in advance!
probably your goaldiff column is a character column instead of an int column.