<?php
require_once("includes/includes.inc.php");

$db->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");
?>