specials.php File Reference

Go to the source code of this file.

Variables

• global $random_product
• $languages_id = $page->the_var('languages_id')
• if($random_product=tep_random_select("select
  p.products_id,
  pd.products_name,
  p.products_price,
  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 p.products_id
  = s.products_id and
  p.products_id = pd.products_id
  and p.products_id
  = p2c.products_id and
  categories_status = 1 and
  pd.language_id = '".(int)$languages_id."'
  and s.status = '1' order by
  s.specials_date_added desc
  limit ".$page->_conf_value('MAX_RANDOM_SELECT_SPECIALS')))
  else $array = array('title'=>'','content'=>'')

---

Detailed Description

Definition in file specials.php.

---

Variable Documentation

if ($random_product=tep_random_select("select p.products_id, pd.products_name, p.products_price, 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 p.products_id = s.products_id and p.products_id = pd.products_id and p.products_id = p2c.products_id and categories_status = 1 and pd.language_id = '".(int)$languages_id."' and s.status = '1' order by s.specials_date_added desc limit ".$page->_conf_value('MAX_RANDOM_SELECT_SPECIALS'))) else $array = array('title'=>'','content'=>'')

Definition at line 20 of file specials.php.

$languages_id = $page->the_var('languages_id')

Definition at line 15 of file specials.php.

global $random_product

Definition at line 14 of file specials.php.

Referenced by tep_random_select().