Selecting multiple from dropdown

[Mibble]

Hello,

I have a list which is dynamically generated, I would like to select more than one item to be included.

What is the easiest way of doing this?

Thanks!

[PallaviDalvi]

i assume that u are creating a dropdown list from the values in a database and want to allow multiple selections. this can be done as

<select name=sel id=sel size=5  [color=red][b]multiple[/b][/color]>

hopefully this is what u wanted else get back with more specific details.

[Mibble]

Hello,

Thank you for responding. This is what I have for code, I have been playing trying to get the right spot to insert your pointer.

Thanks!

	if( empty($pInfo->products_id) ){
	    $iteration = 0;
	}else{
            $getOptionsCount_query = tep_db_query('SELECT count(  DISTINCT options_id ) as count
            FROM  '. TABLE_PRODUCTS_ATTRIBUTES .' 
            WHERE  `products_id`  ='.$pInfo->products_id);

$arr_getOptionsCount = tep_db_fetch_array ($getOptionsCount_query);

    $arr_pas_id = jjg_db_getAttributeSetId($pInfo->products_id, $action);
    if( !empty($arr_pas_id) ){

        $iteration = $arr_getOptionsCount['count'];

    }
}

for($i=0; $i<=$iteration; $i++){
?>
          <tr>
            <td class="main"><?php echo TEXT_PRODUCTS_ATTRIBUTES_SET; ?></td>
            <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . tep_draw_pull_down_menu('products_attributes_sets_id_'.$i, $attribute_sets_array, $arr_pas_id[$i] ); ?></td>
          </tr>
<?php
}
?>
          <tr>
            <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?>
            <?php echo tep_draw_hidden_field('AttributeSetCount', $arr_getOptionsCount['count']+1); ?>
            </td>
          </tr>

[PallaviDalvi]

well...u know ur code better and what and where its doing .... i just gave u the HTML for a select tag...wherever in the code u create one u ought to just add the multiple attribute. tep_draw_pull_down_menu seems to be doing something like that... but i'm not sure...coz the related code is not posted.

[Mibble]

hello there,

thanks, you are pointing me in the right direction. in my functions, i have this, which i know it needs to go into:

// Output a form pull down menu
  function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) {
    $field = '<select name="' . tep_output_string($name) . '"';

if (tep_not_null($parameters)) $field .= ' ' . $parameters;

$field .= '>';

if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);

for ($i=0, $n=sizeof($values); $i<$n; $i++) {
  $field .= '<option value="' . tep_output_string($values[$i]['id']) . '"';
  if ($default == $values[$i]['id']) {
    $field .= ' SELECTED';
  }

  $field .= '>' . tep_output_string($values[$i]['text'], array('"' => '&quot;', '\'' => '&#039;', '<' => '&lt;', '>' => '&gt;')) . '</option>';
}
$field .= '</select>';

if ($required == true) $field .= TEXT_FIELD_REQUIRED;

return $field;
  }

[PallaviDalvi]

so... i assume u've figured it out! hope it does what u intended!

[Mibble]

ummmmmmm, no i havent, am working on it tho, once i am done with this other project! i am learning php code, so some is still Greek to me . . .hmmmmmm, and I am 1/4 Greek!!

[PallaviDalvi]

All the best!

[Mibble]

Hello,

here is where the code is, i have tried all kinds of things, to no avail:

"select products_attributes_sets_id, products_attributes_sets_name size = 3 multiple from " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " order by products_attributes_sets_name"

[PallaviDalvi]

Dear Mibble...u seem to be really really confused!!! 🙂 take a break!
i said add the 'multiple' in the select TAG and not STATEMENT. logically explained...the drop down list is directed to allow multiple selections.