• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
calculate league table

#3
[eluser]Flemming[/eluser]
First of all, I think you have too many tables. What is the benefit of storing match data and result data in separate tables? Every match will have a result, so you could store hometeam_goals, awayteam_goals and overtime in the matches table.

This will make for simpler queries to create your league table.

I may be wrong though, I haven't spent long thinking about this! :-)



Messages In This Thread
calculate league table - by El Forum - 08-30-2014, 12:10 PM
calculate league table - by El Forum - 08-30-2014, 04:04 PM
calculate league table - by El Forum - 09-01-2014, 01:06 AM
calculate league table - by El Forum - 09-01-2014, 02:14 AM
calculate league table - by El Forum - 09-01-2014, 02:21 AM
calculate league table - by El Forum - 09-02-2014, 01:30 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.