I want to desig a website about soccer betting useing DBMAN sql.some tables in the DB like this:
League: LeagueID, LeagueName
Team: TeamID, TeamName, LeagueID
Game: GameID, Date, ????
...................
..................
Game is where my problem lies. I want the Game data to list the date,
score, and which team plays. But that means I have to access the Team table
twice within the same record for Game. What is a better way to handle
this?and how add the data to Database using DBMAN sql easily?
League: LeagueID, LeagueName
Team: TeamID, TeamName, LeagueID
Game: GameID, Date, ????
...................
..................
Game is where my problem lies. I want the Game data to list the date,
score, and which team plays. But that means I have to access the Team table
twice within the same record for Game. What is a better way to handle
this?and how add the data to Database using DBMAN sql easily?