Skip to main content
Inspiring
October 28, 2011
Question

dynamic list/menu with more that one value

  • October 28, 2011
  • 2 replies
  • 1560 views

i am trying to create a dynamic list / menu but pull more that one vlaue from the database. any ideas how this can be done, also once the user has selected the value they want, i want that to populate another area on the site?

thanks in advance

jon

This topic has been closed for replies.

2 replies

Inspiring
October 28, 2011

ok let me explain, when i use the create dynamic menu / list, i select the RecordSet then it give me the option to select the value from the recordset, this comes from the database, what if i want more information from another table within the database to be diplayed?

MurraySummers
Inspiring
October 28, 2011

Can you give an example?  I still am not grasping what you want.  Are you wanting this information to be displayed within the select tag? Like -

Option1 from table1

...

Option12 from table1

Option13 from table2

...

Option22 from table 2

Like that?

Or like -

Option 1 from table 1 and Option 1 from table 2

Option 2 from table 1 and Option 2 from table 2

...

Like that?

See, the more specific information you give us in your first post, the sooner you will get a reasonable answer....

Inspiring
October 28, 2011

sorry, will try and explain more clear

table has example: userid, address1, address two

on the menu on each line of the drop down i want to diplay the userid, address1, address two rather than just the lets say userid

i hope this is clearer

i do apologise

MurraySummers
Inspiring
October 28, 2011

i am trying to create a dynamic list / menu but pull more that one vlaue from the database.

I don't understand what this means - can you say more about "pull more than one value" in the context of this question?

once the user has selected the value they want, i want that to populate another area on the site?

That's pretty simple to do with javascript, e.g,

<select name="foo" onchange="document.getElementById('bar').value=this.value">

On change, that javascript would populate another field with the ID of "bar", with the changed value of the <select> tag.