The following query in getRatings(, , r.week, ASC); failed:
SELECT p.name, p.pos, r.* FROM madcat_opt_progression r JOIN madcat_yearly_player_info i ON i.year = AND i.id = r.id JOIN madcat_players p ON p.id = i.id WHERE r.id = 2241 AND r.year = ORDER BY r.week ASC
MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.id = r.id JOIN madcat_players p ON p.id = i.id WHERE r.id = 2241 AND r.ye' at line 1
League Pulse Fatal Error:
The following query in getRatings(, , i.ovr, DESC); failed:
SELECT p.name, p.pos, i.ovr, r.* FROM madcat_yearly_player_info i JOIN madcat_players p ON p.id = i.id JOIN madcat_opt_ratings r ON r.id = p.id AND r.year = i.year WHERE i.year = AND p.id = 2241 ORDER BY i.ovr DESC
MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.id = 2241 ORDER BY i.ovr DESC' at line 1
