Loaded Commerce Community

             
<?php
$attributes_query = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "'");
           while ($attributes = tep_db_fetch_array($attributes_query)) {?>
              <tr>
                <td class="fieldKey"><?php echo $attributes["products_options_name"]; ?></td>
                <?php
                $option_values_query = tep_db_query("select pv.products_options_values_id, pv.products_options_values_name from ". TABLE_PRODUCTS_OPTIONS_VALUES . " pv, ". TABLE_PRODUCTS_OPTIONS ." po join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " popv on (pv.products_options_values_id = popv.products_options_values_id) where popv.products_options_id = po.products_options_id and popv.products_options_id =" . $attributes["products_options_id"] . " and po.language_id =". (int)$languages_id . " group by products_options_values_id, products_options_values_name");
                echo '<td class="fieldValue">';
                echo '<select name="'.$attributes["products_options_name"].'">';
                echo '<option selected></option>';
                while ($option_values = tep_db_fetch_array($option_values_query)) {
                   echo '<option value="'.$option_values["products_options_values_id"].'">'.$option_values["products_options_values_name"].'</option>';
                }
                echo '</select>'; ?>