Stuff

$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)) {