Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Jul 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Populating a table from dynamic menus

    Background: I have a page with a dependant drop-down menu, where it will be filled with information from the first drop-down menu. All of which is coming from an Access 2000 database. So, for example, you select the "Make", and the "Model" menu is then filled with the appropriate models for that make.

    My problem is that I can't figure out how to make the selection of both of those menus populate a table on a seperate page.

    So basically, If they pick "Honda" and then "Civic" I want to be able to populate a table with information from a database that matches those selections.

    Any suggestions or links to point me in the right direction would be helpful.

    Thanks.

  • #2
    Regular Coder
    Join Date
    Aug 2002
    Location
    São Paulo, Brazil
    Posts
    367
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm not sure I understood.
    If you have cars on the menu; Honda, and when the user clicks on it, you want to load all info about Honda from the database and show in a table?

    Or do you already have everything downloaded and when the user chooses Honda you just want to build a table containing the data about Honda?
    /Daniel

  • #3
    New to the CF scene
    Join Date
    Jul 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a dual drop down menu, one for make, and one for model. WHen the user selects the make, then selects the model, I want it to fill in a table, from a database of information, all the vehicles that are of the make and model they picked.

    So if they pick Honda, then Civic, it will make a table from the database of all the Honda Civics available.

    Thanks.

  • #4
    Regular Coder
    Join Date
    Aug 2002
    Location
    São Paulo, Brazil
    Posts
    367
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In that case you have to do it on serverside with SQL. What serverside language are you using?

    The SQL is something like:
    SELECT cars.* FROM cars WHERE make='Honda' AND model='Civic'
    /Daniel


  •  

    Posting Permissions

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