making a football site and i have a table:
teamstable
and the sql that pulls this info
Pos Team P W D L F A GD Pts
at the min i have it order by Pts
how can i get it to do
if Pts is the same order by GD...
ORDER BY Pts, GD DESC
or
ORDER BY Pts DESC, GD ASC
The first column you specify is the main sort column, later columns determine ties in the sort order.
god yes .... mind went blank thank you ....
