<select name="Hull Construction">
....
<option value="Timber"<?php if ($rs_whatever['fieldname'] == "Timber')
{ echo 'selected="selected"; ?>>3</option>

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"kennyxxxx" <webforumsuser@macromedia.com> wrote in message
news:fp2aol$pj1$1@forums.macromedia.com...
>I have a drop down menu working OK
> here is the code
>
> <td><label>Hull Construction
> <select name="Hull Construction">
> <option>Please select</option>
> <option value="Aluminium">1</option>
> <option value="Fibreglass">2</option>
> <option value="Timber">3</option>
> <option value="Steel">4</option>
> </select>
> </label></td>
>
> My problem is how do I reset the menu when I load the page with the
> database
> stored value
> say timber being menu item 3. At the moment it always opens with "Please
> select"
>
> thanks
>