Display manufacturer name in confirmation email

[Peterkrk]

Hi,
I would like to show in my confirmation email also manufacturer (manufacturers) of the ordered products. In components/com_virtuemart/views/invoice/tmpl/mail_html_pricelist.php I put this code:

$query = 'SELECT `mf_name` ' . ' FROM `#__virtuemart_manufacturers_sl_si` ' . ' WHERE `virtuemart_manufacturer_id` =' .$item->virtuemart_category_id ;
$db->setQuery($query);
$manuname = $db->loadResult();

and after that also

<?php echo $manuname; ?>

It is not working... any suggestions?

Regards,
Peter

[AH]

The manufacturer name is already provided in the item date

Just try echoing

$item->mf_name

[Peterkrk]

Hi,
You have right, it is working.
Thank you very much.

Regards, Peter

[AH]

Thank you for the update.  Great to that your problem is solved.