Developing a Web application using Dreamweaver

am developing a web application and I need some help. I have in my database(MySQL) tables for village linked to the sub county table. Sub county linked to the county table and the county table linked to the District table.

I need to design a web form in dreamweaver using PHP for capturing people's details i.e Name,Date of Birth, Village, Sub county,County and District. But since I'll already have the District,County,Sub county and village in my DB, I need to create a drop down for village which after selection should populate automatically the Su开发者_如何学运维b county,county and district text fields.

You can advise on the best way I could do this.

Cheers.

A simple query is in order? Just use an ajax request to send the selected country to a script, the script should return either XML data to fill the select box with or send the dom select box.

i'd go for the

<select onchange="ajaxGetWhatYouNeedByValue(this.value, 'populate some #id');"><option.....

as i understood your question, you need something like => when you select a village it should return all related data associated with the village. Therefore i suggest you using ajax for background loading needed data.