Jump Menu - dynamic links in database

[multipleintell]

I want to make a jump menu that lists all of the possible "Talent Names" from a query of a MySQL database and then take the use to the URL that goes with the "Talent Name." The URL would be a field in the database. How can I do this? It seems like jump menus are static, but that can't be the case.

Thanks,
Melissa

 

[lebisol]

hm....I would start by making a simple jump menu...then assign URL field and label field to values from recordset.
soo simple form would be:

<form name=&quot;form1&quot;>
  <select name=&quot;menu1&quot; onChange=&quot;MM_jumpMenu('parent',this,1)&quot;>
    <option value=&quot;MY_URL&quot; selected>MY_LABEL</option>
    <option value=&quot;MY_URL2&quot;>MY_LABEL2</option>
  </select>
</form>

then simple substitute "MY_URL" and "MY_LABEL"

....
<option value=&quot;<%=(Rs.Fields.Item(&quot;URL&quot;).Value)%>&quot; selected>=&quot;<%=(Rs.Fields.Item(&quot;LABEL&quot;).Value)%>&quot;</option>
...

give it a try...
All the best!

> need more info?
:: don't click HERE ::