How to create a dynamic drop down menu from a table in your database?

Hi, I have a simple table such as

create table A (
column1 varchar(20),
column2 varchar(20)

I want to create a drop down menu selection  like here in this page :

However, here is the trick, i want this menu to update automatically the choice of selection for each and every row I added into the table A.  Thus if table A has 20 row then this menu will have 20 selection.

Can anyone show me how to approach this issue?
Who is Participating?
have a look at this.

at the end of it, there is an initialisation of the array..u need to populate those from the db query.
Try it and let us know if u find any problems.
there are two ways to do it.

1) using javascript to maintain the dependent dropdown box
2) using server side roundtrip

which way do u prefer?
fylix0000Author Commented:
The javascript seems like a good starting point...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.