Problems with Specials

[Blowin]

Hi...

 

I'm having problems with specials. The specials show up correctly on the home page with the original price crossed out in black and the discount price in red, but when you leave the home page and enter a specific category that has an item that is on special, the regular price and the discount price both show up as the discount price. You can see this problem on my site My Webpage

 

For instance the Sponge Bob kite that I have listed in the specials section shows up correctly on the home page with a regular price of 29.95 and a discount price of 26.95, but if you go to category "Kites" and subcategory "Single Line Kites", Sponge Bob will appear again in the specials section with a regular price of 26.95 and a discount price of 26.95. How do I fix this?

[TomThumb]

Step-By-Step Manual Order Entry contribution

[Blowin]

I'm not sure what this has to do with my problem. I don't need to enter orders, I need my "Specials" to show the correct prices.

[TomThumb]

Sorry I replied to the wrong message.

 

I was unable to duplicate your problem but the code that is causing this is in default_specials.php line 28.

 

     $new = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price, s.specials_new_products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and s.status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

 

Try changing it to

     $new = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price, s.specials_new_products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and s.status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

[Guest]

Checked it out and it worked fine.