I am trying to develop a pretty complicated form. Essentially the user selects from Education, health, or water quality. Then using states the correct follow up questions are asked before all this data is submitted.
However, whenever I try to populate with a db query it acts funny. For example. Health and Education but have a dropdown select for years. Each should load the years available from the database and populate accordingly. However, the health dropdown select for year (which comes after the education) populates its self with the education’s years. If I do a dpm to see what year the health year query gets, it is right, but it does not display on the dropdown.
I hope that makes sense. To sum it up: I have two queries to populate two different year forms. However, both populate themselves with the first query, even though the second one returns the right variables.
Here is the code:
$form['data_set'] = array( '#type' => 'select', '#title' => t('Please Select a Topic'), '#options' => array( 'education' =>t('Education'), 'health' =>t('Health'), 'water' =>t('Water'), ), '#required' => TRUE, ); // If User Selects Education $form['education'] = array ( '#type' => 'fieldset', '#title' => t('What Education Information are you looking for?'), '#states' => array( 'visible' => array( ':input[name="data_set"]' => array('value' => 'education'), ), ), ); //Query DB for Rows $query = db_select('hp_education_years'); $query->fields('hp_education_years', array('id', 'years',)); $query->orderBy('years', 'ASC'); $results = $query->execute(); //define rows $options = array(); foreach ($results as $result) { $options[$result->id] = array( $result->years, ); } $form['education']['year'] = array( '#type' => 'select', '#title' => t('Year'), '#options' => $options, '#states' => array( 'visible' => array( ':input[name="data_set"]' => array('value' => 'education'), ), ), ); $form['education']['level'] = array( '#type' => 'select', '#title' => t('Level'), '#options' => array( 'primary' => 'Primary', 'jhs' => 'JHS', 'shs' => 'SHS', ), ); $form['education']['sector'] = array( '#type' => 'checkboxes', '#title' => t('Sector'), '#options' => array( 'public' => t('Public'), 'private' => t('Private'), ), ); //if user selects health $form['health'] = array ( '#type' => 'fieldset', '#title' => t('What Health Information are you looking for?'), '#states' => array( 'visible' => array( ':input[name="data_set"]' => array('value' => 'health'), ), ), ); //Query DB for Rows $query1 = db_select('hp_health_years'); $query1->fields('hp_health_years', array('id', 'year',)); $query1->orderBy('year', 'ASC'); $results1 = $query1->execute(); //define rows $options1 = array(); foreach ($results1 as $result1) { $options1[$result1->id] = array( $result1->year, ); } dpm($result1->year); $form['health']['year'] = array( '#type' => 'select', '#title' => t('Year'), '#options' => $options, );