Another silly, my dumb modification | Peter's Sports League Standings | Forum
Back to the sports standings script page
Log In
Home
Topic RSS
11:09 pm
I am drawing a blank here on how to edit the query on the standings display. For our recreation ages 10 years old and younger, we put the focus on FUN and do not keep standings so we do not want that displayed. If I only want to display certain divisions (example: divid > 13), how do I do it?
If feel dumb here. I should know this!
12:55 am
Offline
If we start with this query:
SELECT divname, divid FROM sportsdb_divs WHERE conference = $confid ORDER BY divorder
You could filter out divisions this way:
SELECT divname, divid FROM sportsdb_divs WHERE conference = $confid AND divid NOT IN (4, 7, 9) ORDER BY divorder
You could use that "[WHERE|AND] id_for_field NOT IN (list, of, ids)" syntax to exclude items in similar queries.
