Forecaster Rankings

Error in query SELECT k.team_city, k.team_name, k.team_id, (@rank:=@rank+1) as rank, k.score, k.prev_rank, k.prev_score, t.login FROM userteamleagues as k LEFT JOIN userteams as t USING (team_id) WHERE k.league_id=1 ORDER BY k.score DESC LIMIT 0,10 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 'rank, k.score, k.prev_rank, k.prev_score, t.login FROM userteamleagues as k ' at line 1