setOrder("-product_"); $aProducts = $products->getObjects(0,200); //var_dump($aProducts[0]); $smarty->assign('aProducts', $aProducts); $smarty->display('new_posters.tpl'); */ require_once LIB_DIR.'/framework/PaANonGroupingQuery.php'; $dbConnection = PaDbConnection::getInstance(); $qry = 'SELECT meta_category_, name, name_in_url FROM category ORDER BY category_ DESC LIMIT 200'; $aCategories = $dbConnection->fetchAllRows ( $qry); $cat = array(); foreach ($aCategories as $value) { $value->name = utf8_encode($value->name); $cat[] = $value; } $smarty->assign('aCategories', $cat); $smarty->display('new_posters.tpl');