jmcall10 Posted June 15, 2010 Share Posted June 15, 2010 ok, I wanted to do a little project and wondered how the database should be designed. I am a good php coder so the actuall coding of the project would only take a day. However I always struggle with the database design. Ok, basically I want to create a "world cup 2010" project. basically my friends put down their predictions of each game. and depending on the outcome would depend on the points earned. what would the best way to design the database be? any assitance would be appreciated thanks in advance jmcall10 Link to comment https://forums.phpfreaks.com/topic/204894-database-design-help/ Share on other sites More sharing options...
ignace Posted June 16, 2010 Share Posted June 16, 2010 teams (team_id, team_name) games (game_id, game_date_time, game_team1_id, game_team2_id) bets (bet_id, bet_score_team1, bet_score_team2, bet_game_id, bet_user_id) I am not a football fan nor do I know how the world cup works, but this may help you on your way. Link to comment https://forums.phpfreaks.com/topic/204894-database-design-help/#findComment-1072867 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.