Get Manufacturer Of Purchased Item

[Guest]

Okay.. on checkout_confirmation.php it displays the items you're purchasing and also the quantity, but I really want to find the manufacturer as well.

 

I know that the item and quantity are shown using the following two variables:

$order->products[$i]['qty']
$order->products[$i]['name']

So I thought I could do the same for manufacturer, but if I can I'm, not sure what array value it should be.

I've tried:

$order->products[$i]['manufacturer']

just because it seemed the obvious one, but it echoes nothing.

Is there a set value I can use to get the manufacturer?

 

Thanks

[Guest]

I just tried

print_r($order->products);

and it outputs:

Array ( [0] => Array ( [qty] => 1 [name] => test [model] => [tax] => 0 [tax_description] => Unknown tax rate [price] => 4.0000 [final_price] => 4 [weight] => 0.00 [id] => 37 ) )

so I guess there's no manufacturer variable in the array. Could I check the id from the array to use in a mysql query to get the manufacturer?