Problem with view all new products

[DrDre]

this is what happens when i try to load the whats_new as a box on my page.

 

 

This is how i load it into the page

<table width="100%">

<tr>

<Td>

<?php

include(DIR_WS_BOXES . 'whats_new.php');

?>

</Td>

</tr>

</table>

 

And this is my Whats_new.php:

<?php

 

/*

 

$Id: whats_new.php,v 1.31 2003/02/10 22:31:09 hpdl Exp $

 

 

 

osCommerce, Open Source E-Commerce Solutions

 

http://www.oscommerce.com

 

 

 

Copyright © 2003 osCommerce

 

 

 

Released under the GNU General Public License

 

*/

 

 

 

if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) {

 

?>

 

<!-- whats_new //-->

 

<tr>

 

<td id="whatsnew">

 

<?php

 

$random_product['products_name'] = tep_get_products_name($random_product['products_id']);

 

$random_product['specials_new_products_price'] = tep_get_products_special_price($random_product['products_id']);

 

 

 

$info_box_contents = array();

 

/* $info_box_contents[] = array('text' => BOX_HEADING_WHATS_NEW);*/

 

 

 

/* new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_PRODUCTS_NEW));*/

 

 

 

if (tep_not_null($random_product['specials_new_products_price'])) {

 

$whats_new_price = '<s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br>';

 

$whats_new_price .= '<span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) .'<br><br><a href="'.tep_href_link(FILENAME_PRODUCTS_NEW).'">'.'View all New Products'.'</span>';

 

} else {

 

$whats_new_price = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id']));

 

};

 

 

 

$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>'. $whats_new_price.'<br><br><a href="'.tep_href_link(FILENAME_PRODUCTS_NEW).'"> View all New Products</a>' ) ;

 

 

 

new infoBox($info_box_contents);

 

?>

 

</td>

 

</tr>

 

<!-- whats_new_eof //-->

 

<?php

 

}

 

?>

 

 

 

now its weird.. the page loads fine here : http://www.sportsandgames.co.tt/catalog/index.php?cPath=236 which is a main category page

but goes crazy on : http://www.sportsandgames.co.tt/catalog/in...p?cPath=236_238 (sub category page) and also here http://www.sportsandgames.co.tt/catalog/pr...roducts_id=1928 ..

 

another funny thing is it happens from time to time on eahc page so i am confused on whats wrong.. please help

[♥zelf]

You are creating a $whats_new_price variable if the prod is on special here.

	if (tep_not_null($random_product['specials_new_products_price'])) {

  $whats_new_price .= <a href="'.tep_href_link(FILENAME_PRODUCTS_NEW).'">'.'View all New Products'.'</span>';

 

 

Then you are loading that $whats_new_price into info_box_contents, which also has a View all New products link.

	$info_box_contents = array();

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

							 'text' => ''. $whats_new_price.'<br><br><a href="'.tep_href_link(FILENAME_PRODUCTS_NEW).'"> View all New Products</a>' );

 

That's a problem.

[DrDre]

thanks :)

 

I just removed one of the links.