osCmax v2.5 User Manual
Results 1 to 2 of 2

Products Attributes why wont this work right?

This is a discussion on Products Attributes why wont this work right? within the osCommerce 2.2 Discussion forums, part of the osCommerce 2.2 Forums category; Hey guys im back again with a new question i have a bunch of products up right now and they ...

      
  1. #1
    New Member
    Join Date
    Sep 2007
    Posts
    25
    Rep Power
    0


    Default Products Attributes why wont this work right?

    Hey guys im back again with a new question i have a bunch of products up right now and they require to input a size option. My problem is when i go to Products Attributes insert size and the options when i go to my item and click on size my sizes are NOT in order why does it do this? i mean my sizes are in order on my admin Products Attributes page but not on the actually item page. How come?

    Thank you

  2. #2
    New Member
    Join Date
    Mar 2008
    Posts
    9
    Rep Power
    0


    Default Re: Products Attributes why wont this work right?

    changed this line in product_info.php;
    $products_options = 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 = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'");
    to this;

    $products_options = 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 = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'". " order by pov.products_options_values_id");
    All I added was;
    . " order by pov.products_options_values_id"
    Last edited by Stephie; 03-27-2008 at 04:40 PM.

Similar Threads

  1. Amybody got Multiple Products to work yet?
    By bkpie in forum osCmax v2 Customization/Mods
    Replies: 2
    Last Post: 12-16-2005, 08:48 PM
  2. Help! Paypal checkout wont work!
    By hayesb2 in forum osCmax v1.7 Discussion
    Replies: 3
    Last Post: 06-29-2005, 10:05 AM
  3. Why don't popups work when products are added through Admin?
    By Shadeau in forum osCMax v1.7 Installation
    Replies: 1
    Last Post: 05-28-2005, 11:54 AM
  4. Authorize.net wont work. Please Help
    By seandon01 in forum osCMax v1.7 General Mods Discussion
    Replies: 2
    Last Post: 02-21-2005, 07:16 AM
  5. one payment option wont work.
    By someguy in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 11-23-2002, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •