[plh]

Hello,

I want to add the "manufacturer" before "product" in the invoice/receipt.

The field available in products is product.manufacturerid but that gives me a number. Not too helpful.

I changed order.php on line 100 and added the following:

$pids = func_query("SELECT $sql_tbl[order_details].itemid, $sql_tbl[order_details].productid, $sql_tbl[manufacturers].manufacturer,$sql_tbl[products].distribution FROM $sql_tbl[order_details], $sql_tbl[products] WHERE $sql_tbl[order_details].orderid = '$orderid' AND $sql_tbl[order_details].productid = $sql_tbl[products].productid AND $sql_tbl[products].distribution != '', $sql_tbl[manufacturers].manufacturer WHERE $sql_tbl[manufacturers].manufacturerid = $sql_tbl[products].manufacturerid");


In order_data.tpl I added: {$manufacturers.manufacturer} in front of {$product.product}.

But this does not seem to do the trick.
I must miss something somehow and hope someone can guide me in the right direction.

Thanks in advance.