I have a simple 2 option drop down menu which corresponds to a column in my database.
The drop down menu is not populated by the database it is just used to update the data in that 1 column. However I was wondering if it would be possible to make the selected option in the dropdown menu mirror the value currently held in the database.
<select name="attend">
<option value="No">No</option>
<option value="Yes">Yes</option>
</select>
So I would like to make Yes be the selected option if the field it will corresdond to in the database is yes.I know I will need to do a select query but apart from that I'm alittle clueless.
Hope someone can help.