If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / How can I find all the parent categories of the current category?

How can I find all the parent categories of the current category?

Locked

Started by atish78 on 5 May 2009, 2:10 PM · Views: 1,049

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
5 May 2009, 2:10 PM
#1
atish78 avatar

atish78

New Zenner

Join Date:
Apr 2009
Posts:
2
Plugin Contributions:
0

How can I find all the parent categories of the current category?

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