sql_query("select * from text where id='welcome'"); $text = $db->fetched_array(); $smarty->assign("text",$text[0]); $db->sql_query("select * from text where id='whatsnew'"); $text2 = $db->fetched_array(); $smarty->assign("text2",$text2[0]); $db->sql_query("select * from slides order by position"); $slides = $db->fetched_array(); $smarty->assign("slides",$slides); $db->sql_query("select * from cats order by position"); $cats = $db->fetched_array(); $smarty->assign("cats",$cats); $smarty->display("index.html"); ?>