I wondered if anyone can offer me some help with regards the following issue
I'm having. Basically, I've the following table structure containing rows
of results between two football teams. The fields are
Based on the above information, I'm wanting to generate a league table
Finally I also want a tally for the number of points e.g 3 points for win, 1
point for a draw. Do you think this is possible with the basic table I
have, or should I consider putting the result data in a leagues table
working out the fields I have listed above, and then just calculating it and
display it ?
Thanks for any advice.