Dropdown Autopopulate

[beth_hansel]

Hi,

How can I make my dropdown menu pull items from the database dynamically. Right now, everytime we add a new item into inventory, we have to manually add it to the menu. Is there a way to make it automatically pull new the new ones? Also, would there be a way to make the ones that have zero inventory not show up?

Thanks in advance!!!
Beth

here is a sample of the code I'm working with:

<form action="deluxeSFshop.aspx" name="searchbox" id="searchbox">
<input type='hidden' name='sfid' value=87970 >
<select name="c" id="c" onChange="jumpto(document.form1.jumpmenu.options[document.form1.jumpmenu.options.selectedIndex].value)">
<option value="0" selected>pick boys theme</option>
<option value="156240">animals</option>
<option value="156248">backyardigans</option>
<option value="156249">blues clues</option>
<option value="156250">bob the builder</option>
<option value="156261">buzz lightyear</option>
<option value="156262">cars (disney)</option>
<option value="156251">cars-trucks-planes</option>
</select>
</form>

[Fumigator]

There sure is, but it gets into server side languages so you'll want to post your question in the forum for the language you are using (ASP, PHP, etc).

[beth_hansel]

Thanks so much! I will do that.
Beth