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