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 cats order by position"); $cats=$db->fetched_array(); $smarty->assign('cats', $cats); $db->sql_query("SELECT * FROM products ORDER BY cid,position"); $products = $db->fetched_array(); $smarty->assign("products",$products); $smarty->display("sitemap.html"); ?>