Re: Advice requested on system.

Wow, again, thanks for all this effort to help!!

'Position'-field is the position of players mostly, there will also be
e.g. haircolor, favorite music etc., so that won't be recorderd per
match.

Also own goals aren't going to be counted, but thanks for reminding me
of them! (Hope there won't be any ... :) )

I am going to record the score, because i want to leave a margin for
matches where people might forget who scored what goal, now they
can fill out 'unknown' to prevent the score from being incomplete ...

I think i'm going to use the following approach:

 TABLE Players:
   - id
   - active
   - firstname
   - lastname
   - position
   - etc.

TABLE matches
   - id
   - opponent (id)
   - location
   - date
   - home_goals
   - visitor_goals
   - etc.

 TABLE goals
   - id
   - match_id
   - player_id

players.active = 0 would mean a player isn't in the team anymore,
and is invisible in the team-list, but his score is counted, and his
name still appears in matches prior to his departure.

I believe this should work quite correctly, and be quite flexible.

Again, thanks a lot!
Still surprised time after time of the power of PHP/mySQL (either!)

Greetings Frizzle.
Received on Tue Oct 18 02:17:23 2005