Location where the manufacturer Emails are stored

[Snixells]

Hi, 

 

I want to access the manufacturer Email to sent them an Email when they sell a product. 

I already tried 

$id_product=$product['product_id'];
$id_manufacturer= Db::getInstance()->getValue('SELECT `id_manufacturer` FROM `'._DB_PREFIX_.'product` WHERE `id_product` = '.(int)$id_product);
$manufacturer_mail=Db::getInstance()->getValue('SELECT `name` FROM `nnw5_manufacturer` WHERE `id_manufacturer` = '.(int)$id_manufacturer);

but i gives me the error:

 

Table 'myDatabase.nnw5_manufacturer' doesn't exist. 

 

Did they change the location or are there other ways to access the emails ?

Thanks for your replies!

 

 

[Snixells]

Hi,

 

Here is a great module that deal with that issue : http://ndiagasoft.com/en/modules-/17--suppliers-order.html

Thanks, but I would like to do it on my own because otherwise I wouldn't learn anything!

[shokinro]

@Snixells

 

Are you sure you database table name prefix for your store is "nnw5_"? 

You may try to replace `nnw5_manufacturer` with `'._DB_PREFIX_.'manufacturer` and see if it fixes your error.