How to change display results in new products?

[shadowfox70]

How to change " Displaying 1 to 8 (of 130 new products)" to Displaying 1 to 8 (of 130 hottest products)?

 

i found this script

 

<td class="smallText"><?php echo $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td

 

how can i change (TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW) to display hottest?????

 

www.ibohol.com

internet ideas and informations

 

PLs do advise!

 

thanks in advance

[steve_s]

copy code from best selers box that will do the trick

[shadowfox70]

copy code from best selers box that will do the trick

 

hello steve,

 

newb here!!

where can i find that best sellers box?

 

 

thanks :blush:

[shadowfox70]

found it!!!!!

Thanks a lot steve :thumbsup:

[shadowfox70]

i jsut reseted my cache then its still the same :blink:

anyone ???? >_<

[shadowfox70]

any advise ???

i got this as i was amending the new_products.tpl.php

i jsut made some similarity with best_sellers.php

i think the "NEW" defines to a db field?

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_DISPLAY_PRODUCTS_NEW1' at line 1

 

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, p.manufacturers_id from products p, products_description pd where DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= p.products_date_added and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name limit -0, MAX_DISPLAY_PRODUCTS_NEW1

[steve_s]

MAX_DISPLAY_PRODUCTS_NEW1 refers to a configuration field in configuration table recheck sql part from bestsellers might be a bit missing out to give error does best sellers box work ok in right or left column where ever it is

[steve_s]

try this

<?

if (isset($current_category_id) && ($current_category_id > 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) {

?>

<!-- best_sellers //-->

<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => BOX_HEADING_BESTSELLERS);

 

new infoBoxHeading($info_box_contents, false, false);

 

$rows = 0;

$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';

while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {

$rows++;

$bestsellers_list .= '<tr><td class="main"><img src="images/block.gif" border="0" alt="" width="14" height="11"></td><td class="main"><p><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></p></td></tr>';

}

$bestsellers_list .= '</table>';

 

$info_box_contents = array();

$info_box_contents[] = array('text' => $bestsellers_list);

 

new infoBox($info_box_contents);

?>

</td>

</tr>

<!-- best_sellers_eof //-->

<?php

}

?>

 

this will produce the output MAX_DISPLAY_BESTSELLERS can be altered in configuration table might have to overide CSS to give white background