rendered paste body$products_options_name_query = tep_db_query("SELECT DISTINCT popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment, products_options_parents.products_options_parents_id FROM " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib LEFT JOIN products_options_parents ON ( products_options_parents.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND ( products_options_parents.products_options_id = popt.products_options_id ) ) WHERE patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' AND patrib.options_id = popt.products_options_id AND popt.language_id = '" . (int)$languages_id . "' ORDER BY popt.products_options_name");$everything_array = array(); while ($everything = tep_db_fetch_array($products_options_name_query)) { if ($everything['products_options_parents_id'] != '') { $everything_array[] = array('products_options_id' => $everything['products_options_id'], 'products_options_parents_id' => $everything['products_options_parents_id'] ); }}while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {