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 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Aug 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using an excel dbase, HOW DO I DO THIS?

    I'm not sure if this is a Javascript, php, or what....but i'm sure someone here can help me find my answer.

    I need to create a page like this with a state drop down box that fills in the locations below...how would you accomplish this?

    http://gouttrial.com/Contact.aspx


    Thanks for taking the time to help me.
    db

  • #2
    Regular Coder
    Join Date
    Mar 2007
    Posts
    505
    Thanks
    1
    Thanked 19 Times in 19 Posts
    First off, don't use Excel. It is not designed to do what you are looking to do. Use MySQL or MSSQL.

    Secondly, since state information doesn't change very often ( the last time we added a state, it was Hawaii and that was on Friday, August 21, 1959 ), you could just hard code that into your page.

    Just copy and paste it from that site's source code.
    To say my fate is not tied to your fate is like saying, 'Your end of the boat is sinking.' -- Hugh Downs
    Please, if you found my post helpful, pay it forward. Go and help someone else today.

  • #3
    New to the CF scene
    Join Date
    Aug 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can you point me in the direction of this MySql code?

    To be honest, i have only delt with mysql for setting up blogs and message boards...so not much really. I know basic HTML and need some help with this coding stuff.

    Thanks!
    db

  • #4
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts
    Ok - so MySQL, and MSSQL (a short name for Microsoft's SQL Server), are databases. Excel LOOKS a lot like one, but it's not - hence Daemonspyre's plea not to use it. Run your website off a proper database. Access is a proper database, sort of. It's better than Excel, in any case. And it'll teach you enough about databases to realise that it's really not up to the job

    So, you have a database. You need to talk to your database. For this you need to know SQL, and you need to know a server-side language like ASP or PHP. If all these are new terms to you, I'd suggest going to w3schools.com and running through some basic tutorials. Once you have some code up and (nearly) running, chuck it up here if you're stuck and we'll help where we can.

  • #5
    New to the CF scene
    Join Date
    Aug 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    these are not new terms to me....i just haven't used them enough to be proficient in them...i'll check out that website

    thanks for your help guys


  •  

    Posting Permissions

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