How to Show Manufacturers Name

[fat_dog]

Hi folks,

 

I have installed the Inventory Report Stock Level contribution, but it didn't have the ability to sort by manufacturer (a fundemental requirement in my opinion).

 

I've got the "sort by" bit working, and also how it lists by manufacturer ID. What I now need to do is turn the ID into the manufacturer name, and that's where I need your help.

 

This works:

<td class="smallText"><?php echo $products['manufacturers_id']; ?></td>

 

But I need to pull manufacturers_name from the DB and display next to each row under $products (as above) and can't see how this is achieved as the manufacturer name isn't held in the products table?

Edited October 3, 2006 by fat_dog