Set Dropdown Value from DB

[dvent]

Hi All,

I have a form containing a dropdown box. This value is being correctly stored on submission in a field called tenStatus

When the form is reloaded for the user to edit this form, the dropdown box is reverting to the top value in the list of options rather than the value in the database.

My code:

<div class="form-row">
              <label>Status</label>
              <div class="form-item small">
                <select name="tenStatus" class="chzn-select" value="<?=$row['tenStatus']?>">
                  <option>OPTION 1</option>
                  <option>OPTION 2</option>
                  <option>OPTION 3</option>
                  <option>OTHER</option>
                </select>
              </div>
            </div>

How can I obtain this?

Thanks
dvent

[bradgrafelman]

<select> elements don't have a "value" attribute.

Instead, you need to compare the value previously selected with the value of each of the <option> elements and, for the one that mattaches, add a selected="selected" to its opening tag.