drop down menu: populated from search? and then used to update
I have an update page that I have created drop down menus on, so that staff can see what are the proper options for each field. It is important that they are entered correctly as these are 'Enum' types in the database and used for customer access to website features. I would like to:
1. Have the drop down populate to the current database entry on the update page. I can do this now (see line 204) but it just adds a redundant line. This redundant line is okay ultimately if I could also:
2. Then have the choice selected in the drop down list (whether it is a new choice or not) used to update the database on submit.
These are not foreign keys. Everything is in one table, so the example used in the tutorial at http://www.webassist.com/tutorials/Manage-relational-tables will not work.
Thanks. If I get this done, I am done with this project! Yay