drop down box and default outpu

[Grant_Cooper]

I have this code that I am having problems with.

<SELECT name='loc_city' value = '%s' TEXT>
<OPTION value='Medicine Hat'>Medicine Hat</OPTION>
<OPTION value='Other'>Other</OPTION>
</SELECT>

I am trying to update mysql with a form, but I want the value in mysql to show. Is this possible?

I also want to be able to write my value in the drop down box. I haven't found any examples yet.

[jnuneznyc]

Can you clarify your request...

I believe you need a way to set a drop down to the the value of the row you just read from the db. I have a function that will render the drop down with a selection.

I will post a solution tomorrow night ... a bit sleepy. Till then!