Interactive Dropdown Populate

[pratik]

Hi all,

 

Can someone guide me with the code to perform this task...

 

I have a table (mysql db) with few fields... Lets say A, B, C, D & E...

 

Now I want to display all these fields as a radio buttons. When someone selects "C" in radio button, the dropdown next to it must populate with all records of field "C" sorting alphabetically.

 

I don't know how to populate dropdown dynamically as per the choice user makes in radio button...

 

After that, user selects a particular item on dropdown menu. On clicking submit button the result.php must be generated by filter as shown...

 

Select * From <tablename> Where "C"="selection from dropdown"

 

I hope my query is well described. Step-by-step guide would be appreciated.

 

Thanks in advance.