sql_query("SELECT * FROM cats ORDER BY position"); $cats = $db->fetched_array(); $smarty->assign("cats",$cats); if(isset($_GET['id'])){ $catIdURI=$_GET['id']; }else{ $catIdURI=$cats[0]['uri']; } $db->sql_query("select id from cats where uri='".$catIdURI."' order by position"); $catId=$db->fetch_item('id'); $smarty->assign("cid",$catId); $db->sql_query("select * from banners where sid='".$catId."' order by position"); $slides = $db->fetched_array(); $smarty->assign("slides",$slides); $db->sql_query("select * from cats where id='".$catId."' order by position"); $cat = $db->fetched_array(); $smarty->assign("cat",$cat[0]); $db->sql_query("select * from subcats where cid='".$catId."' order by position"); $products = $db->fetched_array(); $smarty->assign("products",$products); $smarty->display("category.html"); ?>