Hi I am looking to sort a table of players on my site.
For instance people are predicting scores, I have everything set and working but was wondering if its possible to set an order and if the order has 2 the same, then order them 2 by something else.
For instance here is the query I am using just to order.
"SELECT * FROM league ORDER BY points DESC";
Now if a user has the same points I would then like to go for goal difference, if that is the same go for goals scored, and if that is the same finally go for persons name.
Is this possible in sql or is this a php algorithm I need?
Thanks