Complicated football league Dynamic Ordering in MySQL?
- by Dan
I have a table 'games' for a football league as follows:
date home_team_id away_team_id home_score away_score
- 1 2 6 21
- 3 1 7 19
I can't figure out how to dynamically generate a list of team ID's ordered by Wins (then points for…