Adding manufacturers name to Orders page

As in the title.
Thanks

I think I have a solution but someone would have check its correct:

[B]/home/virtual/site50/fst/var/www/html/admin/includes/classes/order.php[/B]

$orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_manufacturer, products_model,

from " . TABLE_ORDERS_PRODUCTS . "

order by orders_products_id");

while (!$orders_products->EOF) {

$fix_qty = $orders_products->fields['products_quantity'];

$new_qty = preg_replace('/[0]+$/', '', $orders_products->fields['products_quantity']);

new_qty = $orders_products->fields['products_quantity'];

'id' => $orders_products->fields['products_id'],

'name' => $orders_products->fields['products_name'],

'manufacturer' => $orders_products->fields['products_manufacturer'],

'model' => $orders_products->fields['products_model'],

'tax' => $orders_products->fields['products_tax'],

'price' => $orders_products->fields['products_price'],

'onetime_charges' => $orders_products->fields['onetime_charges'],

 'final_price' => $orders_products->fields['final_price'],

'product_is_free' => $orders_products->fields['product_is_free']);

from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "

and orders_products_id = '" . (int)$orders_products->fields['orders_products_id'] . "'");

$orders_products->MoveNext(); 

No answer here...