listing_specials.php File Reference

Go to the source code of this file.

Variables

  • $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_quantity, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and p.products_id = p2c.products_id and c.categories_id=p2c.categories_id and categories_status = 1 and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC"
  • $listing_split = new splitPageResults($specials_query_raw,$page->_conf_value('MAX_DISPLAY_SPECIAL_PRODUCTS'))

Variable Documentation

$listing_split = new splitPageResults($specials_query_raw,$page->_conf_value('MAX_DISPLAY_SPECIAL_PRODUCTS'))

Definition at line 14 of file listing_specials.php.

$specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_quantity, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and p.products_id = p2c.products_id and c.categories_id=p2c.categories_id and categories_status = 1 and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC"

Definition at line 12 of file listing_specials.php.