osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

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 ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 09-30-2007, 10:18 PM
New Member
 
Join Date: Sep 2007
Posts: 24
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
AHB900 is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 03-12-2008, 07:35 AM
New Member
 
Join Date: Mar 2008
Posts: 8
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 0
Stephie is on a distinguished road
Default Re: Products Attributes why wont this work right?

changed this line in product_info.php;
Quote:
$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;

Quote:
$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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 05:38 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax