Hi all,
I am currently tring to create an online league system for a 5-a-side football league that I run but am having some serious problems trying to the the site to display the results.
here are my tables
tbl_league
-----------
leagueID
leaguename
season
tbl_team
------------
teamID
leagueID
teamname
tbl_game
------------
gameID
homeoraway
goalscored
fixtureID
tbl_fixture
-----------
date
time
location
The problem I'm having is trying to create a query that will allow me to show the results of all games in a league.
for example;
Follys Team 1 vs Randoms Team 5 - played on 21 May - 3pm
To me it seems really difficult because you have the goals scored for each team in different rows.
If anyone could help that would be brilliant.
Thanks alot
Folly
Problems Creating an Online League System
Moderator: General Moderators
Re: Problems Creating an Online League System
Your database doesn't seem to contain enough information. How are you storing which team played in each game? And how do you know which league the game was in?
Re: Problems Creating an Online League System
hmmm.... thats really seems to be the root of the problem I'm having, I'm really not sure how to store the which teams played in which fixture