very_viewed.php File Reference

very viwed boxes More...

Go to the source code of this file.

Variables

• $DB = Database::getInstance()
• $languages_id = $page->the_var('languages_id')
• $best_sellers_query = $DB->query($sql="select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd," . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_status='1' order by pd.products_viewed desc, pd.products_name limit 11" . '')
• if($best_sellers_query->__get('numRows') >
  =(int) MIN_DISPLAY_BESTSELLERS)
  else $array = array('title'=>'','content'=>'')

---

Detailed Description

very viwed boxes

Produits les plues vues, en valeurs absolue

Definition in file very_viewed.php.

---

Variable Documentation

if ($best_sellers_query->__get('numRows') >=(int) MIN_DISPLAY_BESTSELLERS) else $array = array('title'=>'','content'=>'')

Definition at line 31 of file very_viewed.php.

$best_sellers_query = $DB->query($sql="select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd," . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_status='1' order by pd.products_viewed desc, pd.products_name limit 11" . '')

Definition at line 20 of file very_viewed.php.

$DB = Database::getInstance()

Definition at line 18 of file very_viewed.php.

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

Definition at line 19 of file very_viewed.php.