Antwort #17 am: 26. Mai 2009, 23:22:13
Ich habe gerade noch was in einem Forum gefunden, damit wird jetzt alles sortiert, z.B. auch Farbe und Größe nach dem alphabet. Nur alphanumerisch ist es nicht, d.h. das 100, 11, 12 Problem
Weiß nicht genau, was jetzt dafür sorgt, deshalb wird's leider etwas länger:
"/admin/includes/modules/new_attributes_include.php"
Suchen:
$query = "SELECT * FROM ".TABLE_PRODUCTS_OPTIONS." where products_options_id LIKE '%' AND language_id = '" . $_SESSION['languages_id'] . "'";
Ersetzen mit:
$query = "select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS." where products_options_id LIKE '%' AND language_id = '" . $_SESSION['languages_id'] . "' ORDER BY products_options_name ASC";
Suchen:
$query2 = "SELECT * FROM ".TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS." WHERE products_options_id = '" . $current_product_option_id . "' ORDER BY products_options_values_id DESC";
Ersetzen mit:
$query2 = "SELECT POV2PO.products_options_values_to_products_options_id, POV2PO.products_options_id as products_options_id, POV2PO.products_options_values_id as products_options_values_id, POV.products_options_values_name as products_options_values_name FROM products_options_values_to_products_options POV2PO LEFT JOIN products_options_values POV ON POV2PO.products_options_values_id = POV.products_options_values_id WHERE POV2PO.products_options_id = '" . $current_product_option_id . "' and POV.language_id = '". $_SESSION['languages_id']. "' ORDER BY POV.products_options_values_name";
Suchen:
$query3 = "SELECT * FROM ".TABLE_PRODUCTS_OPTIONS_VALUES." WHERE products_options_values_id = '" . $current_value_id . "' AND language_id = '" . $_SESSION['languages_id'] . "'";
Ersetzen mit:
$query3 = "SELECT * FROM ".TABLE_PRODUCTS_OPTIONS_VALUES." WHERE products_options_values_id = '" . $current_value_id . "' AND language_id = '" . $_SESSION['languages_id'] . "' ORDER BY products_options_values_name ASC";