Editable Drop-Down List Box

[TecTao]

I'm useing a simple HTML drop-down list box.  But now I want to be able to and an editable drop-down box so that if the particular item in the drop-down is not changed it won't update the database.  But if a new value is selected it will update the DB with the new value.

 

I am not clear on a couple of things.  should the valuse of the drop down be in a seperate DB table.  And then the script to change the new value or keep the old.

 

I've googled this and can't seem to find a workable solution.

 

Thanks in advance,