meta tags, keywords getting the names frm categories

[Jmus]

hi,

has the current setup of keyword generation for each product info page, it generates a string with the name of the product and all top categories, what i wanted to achieve was a keyword generation like this:

top category wich product belongs + sub-category if any + product name + manufacturer name

can someone help me please'? my php knowladge isnt enough.

i think it has something to do with the code inside, modules->meta_tags.php

maybe this code bellow:

// Get all top category names for use with web site keywords
$sql = "select cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = 0 and c.categories_id = cd.categories_id and cd.language_id='" . (int)$_SESSION['languages_id'] . "' and c.categories_status=1";
$keywords_metatags = $db->Execute($sql);
while (!$keywords_metatags->EOF) {
$keywords_string_metatags .= zen_clean_html($keywords_metatags->fields['categories_name']) . METATAGS_DIVIDER;
$keywords_metatags->MoveNext();
}
define('KEYWORDS', str_replace('"','',zen_clean_html($keywords_string_metatags) . CUSTOM_KEYWORDS));

what do i need to alter to make this work ? thanks.

[Kim]

http://www.zen-cart.com/forum/showthread.php?t=41020