I am trying to add a snippet of the category description to the subcategory listing page, but I cannot for the life of me find the sql that pulls that in. On the category_row.php page, there is a $category variable with the sub category info in it, but I can't tell which page is building this variable so I can add to it. Please help. Thanks.

Not clear what or where you are seeking this??

A link and additional description would help

http://www.bestuniformsinc.com/index.php?main_page=index&cPath=67

This is a category page displaying 3 subcategories. The category description that is normally displayed on the category page after you click the category: I want that description to show up on this subcategory page along with the thumbnail and name. Make sense?

I want that description to show up on this subcategory page along with the thumbnail and name. Make sense?
No, not really - because I already see 3 sub-cat images and descriptions
image=category_thumb_commbars.jpg
Des= Blackinton Commendation Bars
image = category_thumb_designabadge.jpg
des = Blackinton Design-A-Badge
img = blackinton_quick_ship_category_thumb.jpg
des = Blackinton Quick Custom Badges

No, those "descriptions" you are seeing are the category name, not the "description". If you click on Blackinton Quick Custom Badges, you will see the "description" that I am talking about underneath the category title and before the products. Looks something like this:

Choose from 13 select Blackinton badge styles

Customize your lettering, finish and center seal

etc...

I would like this description to show up on the previous subcategory listing page. Make more sense now?

What you're looking for happens in /includes/modules/pages/index/main_template_vars.php starting at line 76. The SQL statements currently don't pull the categories' description.

Thank you lat9. That is what I needed.

One more question. Can you use the overide system somehow for this page?

I created a folder within the modules/mytemplate/pages/index/main_template_vars.php and a folder within modules/pages/index/mytemplate/main_template_vars.php and neither worked. Only modifying the modules/pages/index/main_template_vars.php seemed to work.

Thanks.

I found the following link via Google that provides an override method to allow overrides of the page-specific main_template_vars.php file(s):

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

I'm running v1.3.9h
My test site is at: http://fixyourprofile.com/fasteners/

I would like to have category descriptions displayed on subcategories. I would like the descriptions for "tapping screws", etc. to appear next to the subcategory pictures on this page (and all subcategory pages): http://fixyourprofile.com/fasteners/threaded-products

The only add-on I have installed is Ceon URI Mapping (SEO).

Thanks in advance.

Sean
+<|:-)

Nevermind :)

This problem has been answered here:
http://www.zen-cart.com/forum/showthread.php?t=77958&page=2

THANKS!

The category_row.php solution in posts 7 & 16 of that thread is limited in functionality; it will break down if your database has table prefixes or you use multiple languages. I have just posted a more comprehensive method using main_template_vars.php in that thread.