Dropdown list populated from external database
April 23, 2011 12:00 AM
I am currently trying to figure out how to populate a second dropdown list from a mysql database using php.
I've searched the forum for ideas, tried what I can, but I've got nowhere.
What I am trying to do is;
Page 1. With the first dropdown list, the user selects a department in a dropdown list and posts this to the database where php queries the database table containing departments and sites and echoes the sites which belong to the selected department.
Page 2. Contains the selected department in a text field and has a second dropdown list which is populated from the query (ie showing only the sites associated with the selected department).
Should be possible, but as a newbie to Lectora I don't know where to start apart from in the forum.
Any advice on how to do this, or books contaning advice would be greatly appreciated.
Discussions have been disabled for this post