Upcoming Games!!! | Peter's Sports League Standings | Forum
Back to the sports standings script page
Log In
Home
Topic RSS
10:38 pm
Is there a way to make the Upcoming Games table list only the master teams. I am using this in a football league where each team has a flag, sophomore, junior, and senior team so each master team has 4 teams. But I only need the Master team to show on upcoming schedule because all 4 teams play the same team at the same location. Is that something that can be adjusted pretty easily in standings.php?
12:40 am
Also, is there a way to keep the past games from showing on the web. All I want is the standings columns and the upcoming games columns.
1:22 am
Offline
1. Easy if you know MySQL, but potentially confusing if you don't. In the query at around line 267, add "masterteamname" to the list of fields, add "sportsdb_masterteams" to the list of FROM tables, then add "AND sportsdb_masterteams.masterteamid = sportsdb_teams.teamid" to the WHERE clause. Repeat wherever you need to fetch a team. Then you can display the master team name in a similar way to how the team name is shown.
2. You can simply remove the portion in standings.php from "Past Scores" to "Upcoming Games" :)
