Mysql roster question

Im working on a roster for a sports league. Each team has thier own roster and should be able to add to it in theory. I was wondering if any 1 had any ideas on how to set up the team database. should i make a row for each position in the team (e.g. pitcher, catcher, 1b, 2b etc…)

Also i was wondering if it is possible to have php create a page depending on the information in the database. (e.g. team one would have there own page created from information in database that will show scheduel, roster, profile, standings)

any ideas?