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.

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:

select category_name, product_name
from hikashop_category cat
    INNER JOIN hikashop_product_category pc
    INNER JOIN hikashop_product prod
where
    cat.category_id = pc.category_id
AND
    pc.product_id = prod.product_id;

Hi Nicolas,

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

<?php
  $db =& JFactory::getDBO();
  $sqlreq = "SELECT category_name FROM ".$db->nameQuote('#__hikashop_category')." cat INNER JOIN ".$db->nameQuote('#__hikashop_product_category')." pc WHERE cat.category_id = pc.category_id AND pc.product_id =".$this->row->product_id.";";
  
  $db->setQuery($sqlreq);
  $db->query();
  $result = $db->loadResult();
  ?>
...
...
<?php
unset($db);
unset($result)
?>