Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to link "specials.php" in a sub-category?


sisteligent

Recommended Posts

How can i make this:

 

When a user clicks on a sub-category named "ABC" to display products from specials.php or even to redirect to specials.php?

 

There is a contribution to display only specials in category, but if you link a product to another sub-category, the product

will be displayed twice, so...

 

Here`s a code:

 

if ($AHspecials == 1) {

// We show all specials

$listing_sql = "select " . $select_column_list . " p.products_id, pd.short_desc, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where s.status = '1' and p.products_id = p2c.products_id and p.products_id = s.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "'";

} else {

 

 

is there a way to replace >> $listing_sql = "........ << with a command to display "specials.php" page?

 

 

Hope to find an answer!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...