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!