Adding in additional text into the attributes drop down menu when selecting a product

[SarahL]

When you are in your attribute controller - you have a drop dnown list of all your products in each category - I want to make that drop down have more detail in it - basically I have lots of products that use the same title or product name and so I need to add in another field before it to determine which one you need

I have the field its all set up BUT I can just cannot find the file which pulls the data from MySQL into the select box - can anyone point me too which file this is? I think its a generally used file in Admin area

Site is not used as a shop just the outline so yes I know its core file changes - but that really is ok for what I need for this site

So I know its linekd from this file admin/attributes_controller.php

<?php
    if ($_GET['products_filter'] != '') {
?>
          <tr>
            <td class="main" width="200" align="left" valign="top">&nbsp;</td>
            <td colspan="2" class="main"><?php echo TEXT_PRODUCT_TO_VIEW; ?></td>
          </tr>
          <tr>
            <td class="main" width="200" align="center" valign="top">
<?php
  $display_priced_by_attributes = zen_get_products_price_is_priced_by_attributes($_GET['products_filter']);
  echo ($display_priced_by_attributes ? '<span class="alert">' . TEXT_PRICED_BY_ATTRIBUTES . '</span>' . '<br />' : '');
  echo zen_get_products_display_price($_GET['products_filter']) . '<br /><br />';
  echo zen_get_products_quantity_min_units_display($_GET['products_filter'], $include_break = true);
?>
            </td>
            <td class="attributes-even" align="center"><?php echo zen_draw_products_pull_down('products_filter', 'size="5"', '', true, $_GET['products_filter'], true, true); ?></td>
            <td class="main" align="right" valign="top"><?php echo zen_image_submit('button_display.gif', IMAGE_DISPLAY); ?></td>
          </tr>
        </table></td>
      </form></tr>

<?php
    } // product dropdown
?>

and it linked to products_filter but I cannot get any further than that? If someone could point me to the file that creates the SQL statment I can do the rest :)

thank you
Sarah

138a version