Yeni sayfanın başlısğı
0)) {
$best_sellers_query = tep_db_query("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_ordered > 0 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 '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
} else {
$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
}
if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {
?>
BOX_HEADING_BESTSELLERS);
new infoBoxHeading($info_box_contents, false, false);
?>
';
while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
$rows++;
if ($count ==0 ) $kk=' class="bg_list2_un"'; else $kk=' class="bg_list2"';
$count ++;
if ($count != 0 ){
if ($count <= 9 ) {
$separ = '0';
} else {
$separ = '';
}
$bestsellers_list .= '' . $separ . $count . '. ' . $best_sellers['products_name'] . '';
} else {
$bestsellers_list .= ' ' . $count . '. ' . $best_sellers['products_name'] . '';
}
$rows++;
}
$bestsellers_list .= '';
$info_box_contents = array();
$info_box_contents[] = array('text' => $bestsellers_list);
new infoBox($info_box_contents);
?>