Show Category description on Product info pages

[Commsman]

I need to display the category description text (but not the category image) at the top of the Product Information pages.
I can do this for the Product Listing pages but cannot see how to do it for the Product Detail pages.
Hope someone has the answer to this.
Cheers
J

[kuroi]

You would have to add a database query into the main_template_vars.php pages module for product_info to extract the category description for the page's current language. And then add some further custom code into the tpl_product_info_display.php template to display the result of that database query.

If you are using additional product types that have their own product_info-equivalent pages, you would need to repeat the above changes for each of them.

[spoma]

I am having this same problem. Could someone give a little more detail into what needs to be done here?

[kuroi]

Upon reflection, there's an easier way to do this. Just insert the following where you want this description to appear

<p><?php echo zen_get_category_description(zen_get_products_category_id((int)$_GET['products_id']), (int)$_SESSION['languages_id']) ?></p>

[spoma]

That worked! Thanks for the help.

[spinnywoman]

Thanks for this post. Works a treat!

[sivivatu]

http://www.ksbrands.co.uk/zen/index....roducts_id=486

I'm tryin to get the Category description in the white space underneath the header but can't figure out why it's not working. Any help would be appreciated. Thanks

Here's the code that I am using:

<!--bof Category Icon -->
<?php if ($module_show_categories != 0) {?>
<?php
/**
 * display the category icons
 */
require($template->get_template_dir('/tpl_modules_category_icon_display.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_category_icon_display.php'); ?>
<?php } ?>




<?php
$current_categories_description = "";
// categories_description
$sql = "SELECT categories_description
        FROM " . TABLE_CATEGORIES_DESCRIPTION . "
        WHERE categories_id= :categoriesID
        AND language_id = :languagesID";

$sql = $db->bindVars($sql, ':categoriesID', $current_category_id, 'integer');
$sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
$categories_description_lookup = $db->Execute($sql);
if ($categories_description_lookup->RecordCount() > 0) {
  $current_categories_description = $categories_description_lookup->fields['categories_description'];
}
?>

<?php
// categories_description
    if ($current_categories_description != '') {
?>
<div id="indexProductListCatDescription" class="content"><?php echo $current_categories_description;  ?></div>
<?php } // categories_description ?>



<!--eof Category Icon -->