bschultz Posted June 1, 2010 Share Posted June 1, 2010 The local hospital in town has started a "wellness challenge"...where they want people to form a team of co-workers or friends and collectively, the goal is to walk 100,000 miles this summer. They want a website that will allow people to register, post their miles each week (only team captains can enter mile), and calculate how many miles have been walked (average) by each team member. All of this is working...except for the registration part. I currently have a drop box with team names and their captain's name (in case walkers don't know their team name...but only who their captain is). I also have a spot for "OTHER". I then log into phpmyadmin a couple times a day and "fix" all the others, and add the new teams to the drop box. This way, all team names are typed correctly...etc. Sometimes, the team member (not the captain) registers BEFORE the captain does...so I can't just have the php write the team info to the drop box when the captain registers. What's the best way to handle this problem? Quote Link to comment Share on other sites More sharing options...
bschultz Posted June 2, 2010 Author Share Posted June 2, 2010 I should also ask what's the best layout of the database? I currently have a table for registration, and a separate table for miles each week. Should I add a table for team names? Quote Link to comment 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.