Hello all,

I'm working with
http://addons.oscommerce.com/info/6339

I love this add-on it is so simple to install and does exactly what I want, except for one thing.

It displays the product image and then just the price underneath it.

I would like it to display image, product short discription, price.

I've been fiddling with the code for a day and I'm just not experienced enough to make it work.

I'm sure it's simple for someone out there,

Thank you,
PRV


OsCommerce
Contribution Code
<?php
/*
$Id: new_products.php 1806 2008-01-11 22:48:15Z hpdl $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2008 osCommerce

Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php
$info_box_contents = array();
$info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

new contentBoxHeading($info_box_contents);

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
$category_query = tep_db_query("select distinct categories_id from ". TABLE_products_TO_CATEGORIES );
$cids = array();
while ($categories = tep_db_fetch_array($category_query)) {
array_push($cids, $categories["categories_id"]);
}
$cid = $cids[rand(0, count($cids) - 1)];

// removed order by p.products_date_added desc
$new_products_query = tep_db_query(
"select p.products_id, p.products_image, p.products_tax_class_id, " .
"if(s.status, s.specials_NEW_products_price, p.products_price) as products_price " .
"from " . TABLE_products . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id " .
", ". TABLE_products_TO_CATEGORIES . " p2c " .
"where p.products_id = p2c.products_id and products_status = '1' and (p2c.categories_id = 54)" .

"order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS);
} else {
$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_NEW_products_price, p.products_price) as products_price from " . TABLE_products . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_products_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS);
}

$row = 0;
$col = 0;
$info_box_contents = array();
while ($new_products = tep_db_fetch_array($new_products_query)) {
$info_box_contents[$row][$col] = array('align' => 'center',
'params' => 'class="smallText" width="33%" valign="top"',
'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));

$col ++;
if ($col > 2) {
$col = 0;
$row ++;
}
}

new contentBox($info_box_contents);
?>
<!-- new_products_eof //-->