Dear All,

(Please do excume me if this has already been solved and point me to the right link)

(Zencart ver. 1.38a )
I have been spending hours looking for a way to modify meta_tags.php to do the following:

I would like to show category, sub category, sub_subcategory...N and product name in the KEYWORDS. e.g.

DVDS, Movies, Action, Die Hard

so far it seems impossible and I seek your expert advice.

I have been looking into creating a recurrsive sql query but I can not find if MySQL support reccursive queries like SQL 2005.

I know zencart already displays the tree structure of the categories on the mainpage in a horizontal way but not sure where the query is. Perhaps its a linklist which i got no clue about and im a newbie to PHP/MYsql.

I would really appriciate your help

thanks

Atish