whats_new.php File Reference

Go to the source code of this file.

Variables

  • global $random_product
  • global $price
  • if($random_product=tep_random_select("select
    p.products_id from
    ".TABLE_PRODUCTS." p,
    ".TABLE_PRODUCTS_TO_CATEGORIES."
    p2c, ".TABLE_CATEGORIES." c
    where p.products_id
    = p2c.products_id and
    p2c.categories_id
    = c.categories_id and
    p.products_status = '1' and
    c.categories_status = '1' and
    p.products_date_added >
    SUBDATE(now(), INTERVAL
    ".(int)
    MAX_DATEADDED_FOR_NEWX_PRODUCT."
    DAY) order by
    p.products_date_added desc
    limit ".$page->_conf_value('MAX_RANDOM_SELECT_NEW')))
    else $array = array('title'=>'','content'=>'')

Detailed Description

Definition in file whats_new.php.


Variable Documentation

if ($random_product=tep_random_select("select p.products_id from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c, ".TABLE_CATEGORIES." c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_status = '1' and c.categories_status = '1' and p.products_date_added > SUBDATE(now(), INTERVAL ".(int) MAX_DATEADDED_FOR_NEWX_PRODUCT." DAY) order by p.products_date_added desc limit ".$page->_conf_value('MAX_RANDOM_SELECT_NEW'))) else $array = array('title'=>'','content'=>'')

Definition at line 27 of file whats_new.php.

global $random_product

Definition at line 17 of file whats_new.php.