View Single Post
Old 01-16-2019, 05:01 PM   #6
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
Though nothing there addresses your initial question of listing teams and cities, you can read the first site in my signature for how to set up a MySQL db with OOTP data. From there, getting that list can be done with the following query:

Code:
SELECT teams.name AS city
    , teams.nickname AS 'team name'
    , leagues.abbr AS league

FROM teams INNER JOIN leagues ON teams.league_id = leagues.league_id

ORDER BY teams.name;
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP

Logo Gallery
cavebutter is offline   Reply With Quote