[cflsystems]

Your sql statement is all wrong as well as the smarty code. I am suprised you are not getting an error actually. Don't even try this in order.php. I think manufacturer name is already included in product array but you need to call it properly in the template file

{$product.manufacturer}