I've gotten this mod to display manufacturer ID in the report, but I'd really like it to show the manufacturer name instead. Does anyone know how I can achieve this? Here is the relevant code so far:

$products_query_raw = "select manufacturers_id, products_model, p.products_id, products_quantity, pd.products_name, categories_name from ".TABLE_PRODUCTS." p left join ".TABLE_PRODUCTS_DESCRIPTION." pd using(products_id) LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON(cd.categories_id = p.master_categories_id AND cd.language_id = '$lang_id') $db_category_where group by p.products_id order by $sort $dir";
<td class="dataTableContent" align="center"><?php echo $products->fields['manufacturers_id']; ?>&nbsp;</td>
Or, even better, I'd LOVE to have a dropdown manufacturer filter at the top of the report. Is that possible?

Thanks!