sql_query("select * from diseases where new='1' order by position"); $diseases = $db->fetched_array(); $smarty->assign("diseases",$diseases); //solutions $db->sql_query("select * from solutions where new='1' order by position"); $solutions = $db->fetched_array(); $smarty->assign("solutions",$solutions); $db->sql_query("SELECT * FROM news ORDER BY date DESC,position ASC LIMIT 5"); $news = $db->fetched_array(); $smarty->assign("news",$news); $smarty->display("news.html"); ?>