Adding Category Name to the New Products/Featured/Specials Boxes on Main Page

[chinchilla2]

I'm working on designing a template and I'd like to add the category to the items displayed in the center column boxes so they look something like the attached image. From my poking and prodding on this, I know the necessary pages are in the includes/modules directory, an example would be the includes/modules/new_products.php file. The code that generates the display for that particular page is...

  while (!$new_products->EOF) {

    $products_price = zen_get_products_display_price($new_products->fields['products_id']);

    $new_products->fields['products_name'] = zen_get_products_name($new_products->fields['products_id']);
    $list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsNew back"' . ' ' . 'style="width:' . $col_width . '%;"',
    'text' => '<div style="float: left; padding-right: 5px;"><a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'products_id=' . $new_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $new_products->fields['products_image'], $new_products->fields['products_name'], IMAGE_PRODUCT_NEW_WIDTH, IMAGE_PRODUCT_NEW_HEIGHT) . '</a></div><span class="ml3"><a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'products_id=' . $new_products->fields['products_id']) . '">' . $new_products->fields['products_name'] . '</a></span><br />' . $products_price);

    $col ++;
    if ($col > (SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS - 1)) {
      $col = 0;
      $row ++;
    }
    $new_products->MoveNextRandom();
  }

You'll note, I've added a style command to the div tag as well as inserted a span tag. These will be migrated to the stylesheet after I get them all worked out properly.

Any help I can get on this would be greatly appreciated.

[chinchilla2]

Sorry, don't mean to bump my own thread, but I figured it out... I had to add

left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id
left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id

to the db query for starters. The rest just fell into place.

[Ajeh]

Thanks for the update ... most helpful to have both the question and answer even if you find the solution yourself ...

[chinchilla2]

I know what you mean about having the answer posted, even it is just a smidgen. It's a bit aggrivating to search all day for a solution just to discover "Eureka! I fixed it!" as a reply with no additional information. My little snippet of code may not be the complete solution, but at least it's a starting point for the next one in line.

Have a great day!