little help

[php4me]

i am looking at entering goals of a hockey game by period and time.

ie
period 1 12:43 m.smith assisted by s.johnson ppg

so the above tells the period, time of goal, scorer, assisted by and goal type

any ideas on how i should to this to add goal scorers and penalties

[bpat1434]

How are you wanting to store the information? XML, Database, Flat files?

This sounds like you don't know exactly what you want. That kind of thinking can kill you when starting projects (large or small) because things can balloon out of control rather quickly. That simple one-page site you wanted to create is now a 32-page masterpiece with ajax capabilities, contact forms, and a blog. My point is, if you don't have a defined plan, you can really hurt yourself in that you will inevitably make changes to the code for some other feature and you will stray from what you started from.

If you just want a tracker for goals in a game, I guess I would have to say in a database style, you'd want a few tables:

1. Year

2. Teams

3. Games

4. Players

5. Goal Types

Then each table would have it's own data. The simple tables (like players, year, goal types, and teams) would be something like:

CREATE TABLE `years` (
    `year_id` int(11) NOT NULL AUTO_INCREMENT,
    `year` varchar(4) NOT NULL,
    PRIMARY KEY (`year`)
    UNIQUE `uniqueness` (`year`)
) TYPE=MyISAM;

CREATE TABLE `goal_type` (
    `type_id` int(11) NOT NULL AUTO_INCREMENT,
    `type` varchar(64) NOT NULL,
    PRIMARY KEY (`type_id`)
    UNIQUE `uniqueness` (`type`)
) TYPE=MyISAM;

You can see there are only two columns there (an id, and a value). So for players you'd have player_id and name. If you wanted to expand upon that, you could add jersey #, team id, righty/lefty, etc.

The games table would hold your columns to match up team ids, player ids, goal type ids, and periods.

That's one idea. There are other ways to do it based on how you want it done.

[php4me]

hey bpat

thanks for writing.
i am using a database and have a good idea of what i am trying to accomplish
here is what i am kinda going for

http://sports.espn.go.com/nhl/boxscore?gameId=280317022

just look at the 1st, 2nd and 3rd period summary. the stuff that is below that i have already. just not sure on how to enter or get started to make the summary thing work.

since i have a pretty big db and stuff i could give you access so you could look and see which direction i should go. once i get that i should be able to finish i hope

if interested i can PM you with the info

thanks

[bpat1434]

No need to give me DB access. This should be all on you 🙂 Otherwise, I'm just giving you answers and you're not learning anything.

So if all you want is the "score" tabulation in the top left then there are a few routes you can take.

1. Just store the score per period in the database

2. Store each goal with a record of what person scored it an use the SUM() or COUNT() methods in SQL to get the score per period

So depending on how your tables are (whether you have a dedicated table to games, or you haven't created it yet) then you could just create a new table "goals" which holds the game ID, the player ID, the period, and the type. Then when you query, you can just do:

SELECT COUNT(*) AS `score`, `period`
FROM `goals`
WHERE `game_id` = {$gameID}
GROUP BY `team_id`, `period`

Or something of that nature (you may have to play with the SQL to get the results you expect).

[php4me]

hey bpat,
thanks for the ideas. I was gonna give you access so you could see how the database was set up as it is fairly large.

i will try something with the above suggestion and see where that takes me.