Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to change display results in new products?


shadowfox70

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...