Help Needed With Specials Box - Only Shows Newest Specials

[Amanda12345]

Hi All,

 

I need to find out how to make the specials box retate through ALL the items on special, currently it only shows items that also appear on the front page, ie, the newest items added to specials.

 

Can anyone tell me what to change to make it so the box selects specials from the whole range to display in the box?

 

Many thanks :)

Amanda

[sugiartha]

incase you are not using standard special box, please post the codes to this forum.

[Amanda12345]

Sorry! Ok it like this:

 

if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) {

?>

<!-- specials //-->

<tr>

<td>

<?php

$info_box_contents = array();

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

 

new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS));

 

$info_box_contents = array();

$info_box_contents[] = array('align' => 'center',

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product["products_id"]) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a><br><s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</span>');

 

new infoBox($info_box_contents);

?>

</td>

</tr>

<!-- specials_eof //-->

<?php

}

?>

[squalid]

have you got a setting in admin > config>specials > max display specials

[Amanda12345]

Ah, yes, it was on 12 - I changed it to 99, and all the specials now appear on the front page.

Is there a way to only have 12 on the front page, but have all special rotate through the specials box?

[Amanda12345]

Never mind, I figured it out!!

 

Thanks :)