Whats new? I'd like to eliminate 'Specials'

[UncleSteve]

I'm runing the following 'scrolling' 'Whats New' code in one box, and in another box I'm displaying the 'Specials'.

 

I'd like to know how the code below can be changed to only display 'New' products without displaying 'New Specials' as they are already being displayed in the 'Specials' box.

 

I suppose one work about would be to change the dates on the specials!

 

Any help will be appreciated, and thanks in advance :)

 

<?php
/*  snip for posting */

 $wt_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_date_added desc limit " . 25);
 if (tep_db_num_rows($wt_query)) {
?>
<!-- whats_new //-->
	  <tr>
		<td>
<?php


$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));

while ($random_product = tep_db_fetch_array($wt_query)) {
   $random_product['specials_new_products_price'] = tep_get_products_special_price($random_product['products_id']);
   if (tep_not_null($random_product['specials_new_products_price'])) {
	 $wt .= '<center><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']));
	 $wt .= "</SPAN><BR /><HR>";
   } else {
  $wt .= '<center><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>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '<br>';
  $wt .= "</SPAN><BR /><HR>";
  }
  } 

$info_box_contents = array();
$info_box_contents[] = array('align' => 'center',
							 'text' => '<MARQUEE behavior= "scroll" align= "center" direction= "up" width="100" height="160" scrollamount= "2" scrolldelay= "20" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.$wt.'</span></MARQUEE><p><a href="http://www.mystore.co.uk/store/products_new.php"><B>Click Here To</B><BR>See All New Products</a></p>');

new infoBox($info_box_contents);
?>

		</td>
	  </tr>
<!-- whats_new_eof //-->
<?php
 }
?>

 

Steve