I have a drop down menu; having column names from database table. Now, I have another dropdown menu.
What I want is; When I select column name from first dropdown menu, It shows the values of that selected column name from database table in second dropdown menu.
I have inserted column names for the first dropdown menu in options tag but i want to retrieve all column values based on selected column name from database table.
Here is my code:
<select name="first">
<option selected="true" disabled="disabled">Select an Option</option>
<option value="all">Select All</option>
<option value="a">a</option>
<option value="b">b</option>
<option value="c">c</option>
<option value="d">d</option>
</select>
Where a,b,c,d
are the column names. Please help me out.