Jump to content

bolty2

Members
  • Content count

    27
  • Joined

  • Last visited

  1. sussed it.. so basically if anybody wants the order of the select dropdown to be alphabetical instead of by id then you will need to change order by pa.options_values_id to order by products_options_values_name from in the above message code box, that code will be on your product_info page Thanks
  2. Hi all.. I have the option type feature installed and its an awesome contribution.. For me it works seemless and also works well with the attribute ajax manager.. Anyway, i have a bit of a technical question which im hoping someone can help me with.. Ok, when we use a select box the options it displays are in id sort order.. Now my question is that is it possible to sort this alpabetically. Now ive scanned the code on the product_info page and believe this is the query.. $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.options_values_id"); As you will see this is soerted by options_values_id, now ive tried changing that id to name but no joy, and to be honest the query is well over my head.. So if anyone can shed any light i would be most gratefull.. Thanks all
  3. Hello.. Dont normally comment to much on the forum but after installing this great contribution, which i believe is essential when using the Ultimate SEO URL i think its only right to thank Robert at FWR media for the great work he has done here.. Using this contrib and his version of ultimate seo urls not only works perfectly but has made a big difference in a very short time. I would like to thank you for the work you put into this.. Thanks Ian
×