SELECT box from database

[Ouch]

does anyone know how i can get a select box to default to a value from a database?

a webpage opens and fills itself in from a record on a database, but i need the option to change the infomation


<%=rscourse(&quot;ctemplate&quot%> will = either SCT, photo_basic, photo or photo_comprehensive


<SELECT NAME=&quot;default_template&quot; ONCHANGE=&quot;doSelectChange_template()&quot; STYLE=&quot;position:static;width:264;overflow:visible;font:smaller&quot;
<OPTION VALUE=&quot;SCT&quot; SELECTED>Simple
<OPTION VALUE=&quot;photo_basic&quot;>Basic
<OPTION VALUE=&quot;photo&quot;>Intermediate
<OPTION VALUE=&quot;photo_comprehensive&quot;>Advanced
</SELECT> </font>

Can anyone help me?