swoosh
08-31-2005, 06:24 PM
Hi,
okay I have a small problem. It's about planning an database for our floorballteams needs. We have scoresheets and statistics that we want to put in a database and then show them on our website.
To begin with we have lets say a player. When you click that players name you get his profile. Okay in that profile we want to show his games, goals, assist, points and penalties for every season he has played. Like this
#17 John McEnroe
bla bla bla profile stuff
------statistics-----
season team or league games goals assists points pim
1989-90 juniorleague 5 3 2 5 0
1990-91 juniorleague 10 5 3 8 4
seniorteam 5 3 3 6 0
and so on...
then as the last thing there would be juniorleague summed up and same for the other leagues and teams like this
juniorleague 15 8 5 13 4
seniorteam 5 3 3 6 0
now the problem is that I have no clue how to do these tables and stuff so that they are understandable and easy to use. Anyone that could help me?
Sorry for being a bit "weird" but english isn't my native language so it's hard to explain stuff.
swoosh
okay I have a small problem. It's about planning an database for our floorballteams needs. We have scoresheets and statistics that we want to put in a database and then show them on our website.
To begin with we have lets say a player. When you click that players name you get his profile. Okay in that profile we want to show his games, goals, assist, points and penalties for every season he has played. Like this
#17 John McEnroe
bla bla bla profile stuff
------statistics-----
season team or league games goals assists points pim
1989-90 juniorleague 5 3 2 5 0
1990-91 juniorleague 10 5 3 8 4
seniorteam 5 3 3 6 0
and so on...
then as the last thing there would be juniorleague summed up and same for the other leagues and teams like this
juniorleague 15 8 5 13 4
seniorteam 5 3 3 6 0
now the problem is that I have no clue how to do these tables and stuff so that they are understandable and easy to use. Anyone that could help me?
Sorry for being a bit "weird" but english isn't my native language so it's hard to explain stuff.
swoosh