[Ayla]

So to recap (with a demo query) this is all it needs?:

$products = func_query("SELECT * FROM `products` ORDER BY `field` ASC");
$smarty->assign("new_products", $products);