SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    May 2002
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help on design of mysql db

    alright, i figure before i get down to working out the php i should probably get the db set up right. i'm having trouble visualizing the db and how it would work. for some reason i just don't think one table will work

    what it will be is knowledge base of sorts, but i want it to work with dynamic drop down menus.

    first choice:
    [model]
    b3 -> engines
    b4 -> engines

    you choose b3 you get:
    [engine]
    1.8l g60 -> article
    2.0l 16v -> article
    2.8l vr6 -> article

    [non-engine]
    front brake service [end of the line]
    anti-theft system [end of the line]

    you choose 2.8l vr6 you get:
    [article]
    thermostat r/r [end of the line]
    waterpump r/r [end of the line]



    you choose b4:
    [engine]
    1.9l TDi -> article
    2.0l 16v -> article
    2.8l vr6 -> article

    [non-engine]
    door handle fix end of the line
    diy vag-comm tool end of the line

    you choose 2.8l vr6 you get:
    heater core r/r end of the line

    red = drop down menu
    blue = what's in the drop down menu

    so what i'm wanting is you make a choice, and that determines what is populated in the next drop down menu, there may be some overlapping, such as engines, but they would be filtered by the first choice, so you choose b3 and then in the engines come up specific to b3, then after choosing engine, the next menu has choices based on 'where model = 'b3' and engine = '2.8l' and so forth...

    does any of this make sense? anyone have any guidance on it?
    thanks in advance
    i want to be a nerd....

  2. #2
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You may want use a better description then b3 or b4, not sure what those are. Do you have a layout of the data? IMHO, it's better to start with the actual data then drop downs.

    Example:
    Articles(ArticleID, Author, Publish_Date, Copy)
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  3. #3
    SitePoint Zealot
    Join Date
    May 2002
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    b3 and b4 designate passat models, specifically b3 = 1990-1993 b4 = 1995-1997

    anywho...

    i think maybe it would look like this?

    articles(model, engine, article)

    i think that's about it, i mean it could get more indepth, but really...there's not much to it. maybe that's why i'm having such trouble..i dunno...it's late..
    i want to be a nerd....


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
  •