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

#1
[eluser]mirag3[/eluser]
Hi, i need to generate a league table for 1 season with these columns: position, points, name, wins, wins_ot, loses, loses_ot, goals scored, goals conceded. Rows are sorted by: 1. points 2. goals scored . In this league cannot be draw, overtime is needed. My tables looks like this:

#Matches
- match_id
- hometeam_id
- awayteam_id
- location
- season_id

#Seasons
- season_id
- name
- key

#Results
- result_id
- match_id
- hometeam_id
- awayteam_id
- hometeam_goals
- awayteam_goals
- overtime


I dont know how will look select and view. Can anybody help me please? Thanks much. I can pay some small amount on paypal/skrill after good advices/help.


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.