Developing a php application that uses an html input form and a mysql database. The application allows users to add, modify and delete records. If a record is being modified the application retrieves the record from the db and displays data values in appropriate fields on the form. I am not sure how to display the values selected and retain the functionality of drop down lists and checkboxes. Your help is greatly appreciated.
For drop downs you need to test the option value against the DB value and add 'SELECTED' inside the option tag
<option value="xxx" SELECTED>you option</option>
With checkboxes its the same but add 'CHECKED' in the tag if value matches DB value
hth
