Page 1 of 1

Sports scores page structure question

Posted: Fri Sep 25, 2009 10:23 am
by smk17
I'm quite new to PHP and mysql but I am studying my butt off.

I run a website dedicated to boys high school basketball in the New York area. Right now it is 100% static.

The area I have questions on are the schedule pages.

There are 70 teams that I cover. I want each team to have their own schedule page for the upcoming season. Right now those schedules are in tables on the html page, each on their own page and I manually create them each season and also manually enter the game scores after the game takes place. Since two teams play each other, I have to open team A's page and team B's page and manually type in these scores.

What I'd like to happen.

I've created a database that, for example, has a table in it called "candor_schedule". It has 7 columns of DAY OF WEEK, DATE, TIME, H/A, OPPONENT, VARSITY_SCORE, JV_SCORE.

I have been able to figure out how to create a form where I can enter the schedule, hit submit and have it populate the database and then I have a web page set up where the database info feeds into that page. That I have figured out. Of course I do not enter the game scores yet because they haven't been played yet.

And since I have to fill the schedule table out before the season starts, I need to go back and enter the game scores weeks later into the same table? But this is not the correct way to do this I know.

I'd like to have a form where I can enter the game (both teams, both scores, and then that info gets fed into each teams schedule, so I don't have to open up both teams pages, I can do it once from one place.

Can someone guide me in the right direction and try to explain the structure that might work? Do I need to make another table for the scores? And do I need a table for each team?

Here is the static page of one of the schedule pages: http://section4hoops.com/pop/iac_schedu ... ndor_s.htm

And here is the dynamic page test: http://section4hoops.com/php_test/index.php

Thanks for any help
Steve

Re: Sports scores page structure question

Posted: Sat Sep 26, 2009 2:53 pm
by Ollie Saunders
You want to know what database structure to use for storing a team's match scores, along with the match schedules you already have?

Re: Sports scores page structure question

Posted: Sat Sep 26, 2009 4:31 pm
by John Cartwright
Duplicate. Locked.