ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Help! Building a tour stop database

August 31, 2009 1:41pm

Subscribe [3]
  • #1 / Aug 31, 2009 1:41pm

    techops

    18 posts

    Does anyknow know how I would build/structure a database to hold a tour stop listing with states, metro’s and regions?

    I would like to build it so that when the client goes to add a tour stop, they would choose the state from a select list, then the next select would populate with the metro areas in that state, then once a metro is chosen, the next select would populate with the regions.

    I’ve tried a couple different ways but I can’t seem to figure out the correct way to do this. I have FieldFrame, Playa, Gypsie and other extensions installed…

    Thanks in advance!

  • #2 / Sep 01, 2009 1:30pm

    techops

    18 posts

    anyone? I’m struggling trying to figure out the best way to do this.

  • #3 / Sep 01, 2009 1:35pm

    Ingmar

    29245 posts

    I’d probably use an entry per stop, together with categories. Also, an SAEF most likely. I’m sure there are other ways.

  • #4 / Sep 01, 2009 2:04pm

    Justin Long

    196 posts

    I would do each stop as an entry in a weblog. You could use an extension such as http://www.hccdevelopment.com/Web-Based-Software/Product/country_selector/ to select a state. Right now it does not go down to cities or regions but that wouldn’t be to hard to add. Then you could post all of your other details in the weblog

  • #5 / Sep 01, 2009 2:05pm

    Justin Long

    196 posts

    I would do each stop as an entry in a weblog. You could use an extension such as http://www.hccdevelopment.com/Web-Based-Software/Product/country_selector/ to select a state. Right now it does not go down to cities or regions but that wouldn’t be to hard to add. Then you could post all of your other details in the weblog


    sorry about the double post my internet connection is a little buggy right now

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases