php mysql database.
Hi, i'm looking for a new way to do my hockey team stats for me and my friend. We like to look at
them and talk about them durring the week, you know, just fun stuff. Since this is a personal thing
that i don't have time to do, i'm not looking to spend a whole lot of money, so it doesn't need to be
done in 1 day (if that helps on price). I will want more added a later date also, so we can work
together more. Please make sure you understand what i want before bidding.
I want this done in PHP using mySql as the database, it should be easy & quick for someone who knows
this stuff.
Right now this is done by hand (html). I would like to get it all in a database so i can manage it
better and be able to get better stats in the future, and not have to do so much by hand. Here's the
rundown of what i do and what is done.
The hockey league i play on is 10 games plus 2 playoff games (if we make the playoffs), so 12 games
per season. After each game i put the our team stats, and stats for a few people (me and my 2 good
friends). Here are the fields i use.
For each season i have:
Season # (every season it increases by 1, can also be a letter + #, like g1, w1, s1, etc)
Location (the rink name)
Season date (start and end dates, mm/dd/yy - mm/dd/yy)
Team Name (my team name)
Level (what level the league is)
Day (day of week it is)
For each game i do this:
season #
Team Name (my team name)
game # (1-12)
date (date the game is on, mm/dd/yy)
time (time of game hh:mm, 12 hour format)
opponent (team we play)
Win/loss/tie (if we W, L, T)
Goals For (GF) (how many goals we get)
Goals Against (GA) (how many goals we let up)
Game Notes (a link to an HTML file that we type what happened).
For each player that i want to do stats for that season i have the following info:
Player Name (the name)
Season # (season we are in, 1-???)
game # (1-12)
goals (how many goals that game)
assists (how many assists)
points (=g+a) (goals + assists)
Penalty Minutes (how many minutes in penaltys)
This is all i want to put in the database. The i can have a page that shows
all of the Season #'s Level, and team name.
then when i click one, it pulls up a table that shows the headers
Game # - Date - Time - Opponenet - W/L/T - GF - GA - Record - PlayerName - PlayerName - Game Notes
or something close to that, then it shows all the stuff. I included a jpg of what it currently looks
like (done manually).
Please write with any question, or samples, etc.
Thanks for your time
Brian