Results 1 to 2 of 2

Thread: MySQL/PHP help DreamWeaver CS6

  1. #1
    Join Date
    Jan 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question MySQL/PHP help DreamWeaver CS6

    Quote Originally Posted by dravalanche View Post
    I am trying to build a form in schedule.php which adds data to the table schedule. In order to fill in some form fields, needs to be populated with information from another table (locations).
    ...
    What I want to do is have the "Location Name" field display as a drop-down menu, that is dynamically populated with all the entries in the "LocationName" field in the Locations table. After making the selection from the drop-down menu, I'd like to have the rest of the fields automatically populate with the information that corresponds to the selection the user makes.

    ...how do I get the dynamic drop-down menu populate the rest of the fields? I've tried experimenting with recordset queries with a filter based on the drop-down selection, but I couldn't get that to work (I think I may have been barking up the wrong tree, anyways).

    ...is there a way I can have the drop-down menu automatically populate the fields below upon users making their selection, or would I need to create a "Submit" button to perform that action?

    ...After creating the record to be added to the schedule table, should I be content with creating entirely new fields in the schedule table that is populated with data that already exists in the locations table, or is there a way I can link the two in the record I'm creating in the schedules table (thus, eliminating unnecessary redundancy)?
    Quote Originally Posted by dravalanche View Post
    Hey, Boogyman

    After much hemming and hawing (and a lot of beer), I think I figured it out. It's not the perfect solution, but it's effective. Thank you very much for your suggestions, though! Guys like you keep innovative web development going!!

    Cheers!
    @dravalanche:

    Hi dravalanche, please could you kindly throw in some help on how you achieved your case years back. I am using CS6 with MySQL and PHP and my PHP skill is not worth it for now. I am building a project that has similar population like yours.

    Your kind help is highly appreciated.

    Prince Mike

    Mod's note:

    @PrinceMike, please don't post in very old threads. (Anything older than 6 months is generally considered "dead.") @dravalanche was active for only four days, in 2007. When you have a question of your own, start a new thread.

    Please also give specifics about your situation, including any relevant code. In this case, a lot will depend on how your database schema is defined, as well.

    You can read our general FAQ or the posting tips thread for more about the forums. Welcome to DynamicDrive!
    Last edited by traq; 01-19-2014 at 06:57 AM. Reason: paraphrased original question, mod's note

  2. #2
    Join Date
    Feb 2007
    Location
    Earth
    Posts
    130
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Default

    I have 2 suggestions.

    One is learn javascript. It is great for exactly what you are looking for.

    The other is to make the drop down menu also a submit, so that when the user selects something, the form submits to itself the selection of what they chose and can populate the other fields accordingly. I have a feeling if dravalanche stuck with php, they probably went down something along this route.
    http://www.insanecombat.com << bored? check out ma game

Similar Threads

  1. Dreamweaver PHP/MySQL WAMP help
    By rdjain in forum PHP
    Replies: 2
    Last Post: 10-29-2009, 07:00 PM
  2. Dreamweaver and PHP and Mysql
    By Rockonmetal in forum Computer hardware and software
    Replies: 3
    Last Post: 09-26-2008, 11:16 PM
  3. MySQL/PHP help in Dreamweaver CS3
    By dravalanche in forum MySQL and other databases
    Replies: 5
    Last Post: 11-22-2007, 04:22 PM
  4. PHP, Dreamweaver and MySQL
    By Curly73 in forum MySQL and other databases
    Replies: 2
    Last Post: 09-04-2007, 10:30 PM
  5. PHP, Dreamweaver and MySQL
    By Curly73 in forum PHP
    Replies: 0
    Last Post: 07-27-2007, 09:14 AM

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
  •