How can I display the category descriptiong text on the product display info page?

If a product is in 2 categories I also want to display both category descriptions on the product display info page

Thank you

You would have to determine what to do with the results, but something like this will grab all of the categories_descriptions for the product for the tpl_product_info_display.php ...

<?php
  $all_categories = "SELECT categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = '" . (int)$_GET['products_id'] . "'";
  $all_categories = $db->Execute($all_categories);
  $all_categories_description = "";
  while (!$all_categories->EOF) {
  // categories_description
    $sql = "SELECT categories_description
            FROM " . TABLE_CATEGORIES_DESCRIPTION . "
            WHERE categories_id= :categoriesID
            AND language_id = :languagesID";

    $sql = $db->bindVars($sql, ':categoriesID', $all_categories->fields['categories_id'], 'integer');
    $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
    $categories_description_lookup = $db->Execute($sql);
    if ($categories_description_lookup->RecordCount() > 0) {
      $all_categories_description .= $categories_description_lookup->fields['categories_description'];
      $all_categories_description .= '<br class="clearBoth" />';
    }
    $all_categories->MoveNext();
  }
  echo $all_categories_description;
?>