Drop Down Box Dynamically Filled With Taxonomy

I asked a similar question here: http://drupal.org/node/47247

I still haven't figured out how to do it yet. I'll let you know if I find out how to do it.

2 of my Drupal sites:
Small Farm Resource Center
Israel Travel Center

I'm populating a select menu (aka drop-down, jump menu) on my site by dynamically pulling terms from a particular vocabulary out of the taxonomy tables in the database. In addition I'm using the term description for the displayed select items. Here is the code I used:

//Default Value for Select
$t_description[] = 'List by State';
//Get Taxonomy Terms in Vocab State
$result = db_query("SELECT term_data.description, term_data.tid FROM term_data WHERE term_data.vid=1 ORDER BY description");
//Populate array with descriptions and links. The key of the array will be our URL.
while ($term = db_fetch_object($result)) {
  $t_description['http://www.americanpublicradio.com/gov/views/'.$term->description] = $term->description;
}
//Build the select list using Drupal's 'form_select' function.
$category_select = form_select('', 'category', '', $t_description, $description = NULL, 'on Change="top.location.href=document.getElementById(\'edit-category\').options[document.getElementById(\'edit-category\').selectedIndex].value"', $multiple = FALSE, $required = FALSE);
//Give our subsequent form a name we can grab with the Javascript
$form_attributes[description] = 'state_jump';
//Build our form with Drupal's 'form' function.
return form($category_select, $method = 'get', '', $form_attributes);

I based this code off of something I found on this site, I think in the handbooks, I just can't seem to find it again. There was also a different version with a submit button that didn't use any java script. If I can find it again I'll put up the link here. In the meantime, I hope this helps.

good example, maybe contribute to documentation.

Apache is bandwidth limited, PHP is CPU limited, and MySQL is memory limited.

Here's that link I was looking for, that I used as a starting point for the example code above:

http://drupal.org/node/17762

---
To keep the community strong, please answer as many questions as you ask.

Here is a little code snippet that might be of use to someone:

It allows hierarchies to show in multiple select fields....

  $form['category'] = _taxonomy_term_select(
  											"category to search", 
  											"category", 
  											$edit['category'], 
  											2, 
  											t('Select the name of the category you are searching for.'), 
  											TRUE, 
  											"", 
  											array()
  										);
  										

OK, here's a complete, working 4.7.x version of a Taxonomy Select Menu snippet that you can use for a block, on a page, or wherever you can put some PHP on your site. Only 4 or 5 things you need to change in the code below:

1) Where it says $vid=1;, replace the number 1 with the vocabulary ID number for the vocabulary you want to use to populate the drop-down with the terms in that vocabulary.

2) Where it says $formname="Company";, replace the word Company with the word(s) you want your users to see as the default text in the drop-down after List by.

3) Optional: Where it says $options[] = t('List by ' . $formname);, replace List by with the word(s) you want at the beginning of the default text in the drop-down.

4) Where it says $options['http://www.yoursite.com/taxonomy/term/'.$term->tid] = $term->name;, replace yoursite.com with the URL of your drupal website.

5) Where it says return drupal_get_form('Company_dropdown', $form);, replace the word Company with the same word you used in step 2) above - these two text strings must match.

$vid=1;$formname="Company";
$vocabulary = db_query("SELECT term_data.name, term_data.tid FROM term_data WHERE term_data.vid=$vid ORDER BY name");
$options[] = t('List by ' . $formname); // Initialise the country array
//Populate array with url / name
while ($term = db_fetch_object($vocabulary)) {
$options['http://www.yoursite.com/taxonomy/term/'.$term->tid] = $term->name;
}
//Build dropdown select
//If we try to build OnChange directly it gets mangled, so put in array to confuse the forms api
$form['category'] = array(
  '#type' => 'select',
  '#name' => $formname,
  '#id' => $formname,
  '#title' => '',
  '#default_value' => '',
  '#options' => $options,
  '#description' => '',
  '#multiple' => $multiple = FALSE,
  '#required' => $required = FALSE,
  '#attributes' => array('onChange' => "top.location.href=document.getElementById('$formname').options[document.getElementById('$formname').selectedIndex].value"),
);
//Output the form
return drupal_get_form('Company_dropdown', $form);

Thanks to everyone who contributed to this thread!

---
"Please drupal responsibly: give as much help as you get."

I´ve implemented it creating nodes as explained by colorado in the comment above http://drupal.org/node/48843#comment-167478

The implementation was really easy, no more than an hour. I really want to thanks colorado.

Manuj, if you're still interested, take a look in
http://www.inforo.com.ar/AccesoRapido2

Regards,
Gustavo

Anyone working on the URL alias problem?

Many thnx in advance.

There is now a module, Views Filter Block, that accomplishes this for Drupal versions 4.7.x and 5.x:

http://drupal.org/project/views_filterblock

---
"Please drupal responsibly: give as much help as you get."

Hi,

I installed quiz module.After that i created one Vocabulary using admin/cateroies addvocabulary with multichoice type after that I created some sub vocabulary under that now when I am going to create quiz and going to addquestion tab I can choose vocabulary which i created but when i press button callled "filter question list" the question are not filter as per vocabulary.

Do you have any solution regarding my query ??