netman182 Posted November 29, 2009 Share Posted November 29, 2009 first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause i am posting in the wrong area. I am starting from scratch with a new registration form for a soccer league i manage a website for. I am having a brain cramp on how to do a few things. i have a layout in my head but i cant seem to get it to code. so i am starting over. what we want is managers to register their players for the rosters of their own club. We have 6 divisions with 42 teams. so on page one we would like to have to selection boxes which take info from DB Tables. One for division and one for team. on the second page we would like to have the players information filled in so it can be put into another table for that team. and a master table for the entire league. we need to have tracking dates for the additions as well. my question is would i need to the following tables and how can i do this with the least amount of code as possible: - Divisions - Teams - Master Player list - Team List i will probably have more questions regarding this as i go along. thanks stefan Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/ Share on other sites More sharing options...
damdempsel Posted November 29, 2009 Share Posted November 29, 2009 When they register a team, what would you want them to enter? ie: team name, player names, player numbers, coach name. Also, would you need them to have an actual account where they can edit different things? **Typed my question wrong. How many of each field would you need? What would the max amount of players be? Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/#findComment-967339 Share on other sites More sharing options...
netman182 Posted November 29, 2009 Author Share Posted November 29, 2009 initiallly there will be two drop boxes. one with divisions and another with teams when the divsion is selected the teams drop box will be filled with the divisions teams then they will submit that page and be taken to another page where they will fill in the players information. Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/#findComment-967344 Share on other sites More sharing options...
damdempsel Posted November 29, 2009 Share Posted November 29, 2009 Is there a certain amount of teams in each division? Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/#findComment-967349 Share on other sites More sharing options...
netman182 Posted November 29, 2009 Author Share Posted November 29, 2009 typically 7 in some occasions 12 Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/#findComment-967350 Share on other sites More sharing options...
damdempsel Posted November 29, 2009 Share Posted November 29, 2009 You can look at the bit I currently have. It is just the first page where you select the division and team. Gah. The link doesn't want to post. http://damdempsel.netne.net/testfiles/soccer.php Lets hope this works! How many players are on a team? Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/#findComment-967361 Share on other sites More sharing options...
netman182 Posted November 30, 2009 Author Share Posted November 30, 2009 can't i see how it works. it is giving errors. thanks for this btw Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/#findComment-968292 Share on other sites More sharing options...
Philip Posted November 30, 2009 Share Posted November 30, 2009 Reading over this, you'd need these tables... unless you can have multiple divisions per team, or multiple teams per player: Divisions Teams Players Quote Link to comment https://forums.phpfreaks.com/topic/183258-registration-form/#findComment-968296 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.