Arrow

Another silly, my dumb modification | 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

Home Forum Peter's Sports League Standings Another silly, my dumb modification

Another silly, my dumb modification
Page:   1   Reply to Post Add a New Topic
UserPost

11:09 pm
July 30, 2008


Jay

Guest

  Quote and Reply
  Report Post
Print this Post
1

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
July 31, 2008


Peter

Admin

posts 732
  Quote and Reply
  Report Post
Print this Post
2

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.
Page:   1   Reply to Post

Reply to Topic:
Another silly, my dumb modification

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:
11 + 12    

Topic RSS