Aufsteigend Und Absteigend Sortieren

[nom]

Hallo,

brauche Rat, wie kann man Produkte nach Preis sortieren mit Dropdownmenu? Habe folgendes:

default.php

  // optional Product List Filter Price
  if (PRODUCT_LIST_FILTER > 0) {
   if (isset($_GET['products_id'])) {
    $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p.products_id = '" . (int)$_GET['products_id'] . "' order by cd.products_price";
   } else {
    $filterlist_sql = "select distinct m.products_id as id, m.products_price as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_PRODUCTS . " m where p.products_status = '1' and p.products_id = m.products_id and p.products_id = p2c.products_id and p2c.categories_id = '" . $current_category_id . "' order by m.products_price";
   }
   $filterlist_query = xtc_db_query($filterlist_sql);
   if (xtc_db_num_rows($filterlist_query) > 1) {
    $price_dropdown= xtc_draw_form('filter', FILENAME_DEFAULT, 'GET') .'';
    if (isset($_GET['products_id'])) {
     $price_dropdown.= xtc_draw_hidden_field('products_id', $_GET['products_id']);
     $options = array(array('text' => TEXT_ALL_CATEGORIES));
    } else {
     $price_dropdown.= xtc_draw_hidden_field('cPath', $cPath);
     $options = array(array('text' => TEXT_AUFSTEIGEND));
    }
    $price_dropdown.= xtc_draw_hidden_field('sort', $_GET['sort']);
    while ($filterlist = xtc_db_fetch_array($filterlist_query)) {
     $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
    }
    $price_dropdown.= xtc_draw_pull_down_menu('filter_id', $options, $_GET['filter_id'], 'onchange="this.form.submit()"');
    $price_dropdown.= '</form>' . "\n";
   }
  }

Habe das Menu aber mit Preisen drin.