SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Non-Member jake4974's Avatar
    Join Date
    Jan 2006
    Location
    Down the road, it's where I'll always be
    Posts
    357
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Construction advice or something...

    I'm wanting to know what people think would be the best way to go about this. I'll try and explain as clearly as I can.

    I need to display info about meeting times for a bunch of "subcommittees".
    Some of these subcommittees meet at fixed times. No problem I can just say like 3 Saturday of the month or something.
    Some meet on a "non-fixed" schedule. Again not much problem, I can just say like Tuesday, February 12, 2006.
    Now my problem. Meetings whose times are currently fixed could in the future have "dynamic" meeting times, and vice versa.
    A "static" time and a "dynamic" time have different information that needs to be stored. Which set of information displayed needs to be decided somehow.
    I can see how to do this via server side scripting, but is there some MySQL 4 trick or function I'm not aware of that can prevent a situation where I need two queries for each meeting? (which one gets executed dependant on a variable I would also need to store)

    Ooh, today I am full of questions, and hopefully this one makes sense

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,276
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    add a column to your table that distinguishes between the two types of meeting

    then all you have to decide is whether the "different information that needs to be stored" should go into separate subtype tables, or whether they can share columns in the single supertype meeting table

    for more info, do a search on subtype/supertype
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Non-Member jake4974's Avatar
    Join Date
    Jan 2006
    Location
    Down the road, it's where I'll always be
    Posts
    357
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanx man


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •