Problems Creating an Online League System
Posted: Fri Apr 11, 2008 12:43 pm
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
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