category displayed in product listing

Hi,

on my front page, i would like to display not only the list of all products that my eshop sells, but for each product i would like to display the category to which it belongs too.
for example, if eshop dispaly 10 business cards, i don't want to see only their image, name, price and add to cart button but also the category "business card"

1. what is the template i should modify for that ?

when user clicks on a specific product to see its detailed information, i would like also to display its category in its details...

2. once again, what is the template i should modify for that ?

thx.

Hi,

It will depend on the item box box layout you're using for your products listing. If it's the default one, 'image and title', it's the file "listing_img_title" of the view "product" that you should edit.
For the product page, it's the file "show_default" (or "show" before 1.5.6) of the view "product".
These view files can be edited via the menu Display->Views.
You will first have to load the category of the product with a mysql query before being able to display its name.

thank for your help.
so if i must write a MySQL request, where will be the best place to do it ?
i'm afraid to write a MySQL request directly to the listing_img_title php file.... because it could really slow the display of product listing, no ?

AFAIK, the SQL request should be something like:
in order to get the category name

Hi Nicolas,

basically i wrote the following code into the template called "listing_img_title"

Yes. Indeed writing a more complex query/code in order to do it only once would be better performance-wise. I said that because it's simpler to do for you.

If you want to go the complex way, you will have to do the query in "listing" of the view "product", save the results in $this and then loop through them in the listing_img_title file in order to display the proper category name.