Also, you can add the manufacturer into the newproducts.php page by putting this into newproducts.php:
PHP Code:
if (is_array($newproducts)){
foreach($newproducts as $k => $v) {
$newproducts[$k]["manufacturer"] = func_query_first_cell("SELECT manufacturer FROM $sql_tbl[manufacturers] WHERE manufacturerid IN (SELECT manufacturerid FROM $sql_tbl[products] WHERE productid ='$v[productid]')"); }}
right above:
PHP Code:
# flag set that is used in home_main.tpl
$smarty->assign("main","newproducts");
cheers!