tendremos que añadir lo siguiente:
$product_manufacturers_query = tep_db_query("select manufacturers_name, manufacturers_image from manufacturers where manufacturers_id = '" . $new_products['manufacturers_id'] . "'");
$manufacturers_info = tep_db_fetch_array($product_manufacturers_query);
Esto para el caso de new_products
Y luego añadir:
$manufacturers_info[manufacturers_name]
Donde queramos que aparezca el nombre del fabricante