Arrow

Upcoming Games!!! | Peter's Sports League Standings | Forum

Back to the sports standings script page
 
Current User: Guest
Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Upcoming Games!!!

Reply to Post Add a New Topic
UserPost

10:38 pm
September 23, 2009


Regmac

Guest

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
September 24, 2009


Regmac

Guest

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
September 24, 2009


Peter

Admin

posts 732

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" :)

11:50 pm
September 24, 2009


Regmac

Guest

Thanks, I was able to remove the Past Scores but I have to work on the teams part. Don't really know SQL yet, but I will in about a week. (I'm in for some long nights and Dr. Peppers)

Reply to Post

Reply to Topic:
Upcoming Games!!!

Guest Name (Required):

Guest Email (Required):

HTML Editor
Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
9 + 3