<?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'])){
	$db->sql_query("select id from products where uri='".$_GET['id']."' order by position");
	$pid=$db->fetch_item('id');
	$db->sql_query("select * from products where id='".$pid."' order by position");
}else{
	$db->sql_query("select * from products order by cid,position limit 1");
}

$product = $db->fetched_array();
$smarty->assign("product",$product[0]);

$db->sql_query("select * from sgallery where pid='".$product[0]['id']."' ORDER BY position");
$images = $db->fetched_array();
$smarty->assign("images",$images);

$catId=$product[0]['cid'];
$smarty->assign("cid",$catId);


$db->sql_query("select * from subcats where id='".$catId."' order by position");
$cat = $db->fetched_array();
$smarty->assign("subcat",$cat[0]);

$db->sql_query("select * from banners where sid='".$cat[0]['cid']."' order by position");
$slides = $db->fetched_array();
$smarty->assign("slides",$slides);

$db->sql_query("select * from subcats where cid='".$cat[0]['cid']."' order by position");
$cat2 = $db->fetched_array();
$smarty->assign("subcats",$cat2);

$db->sql_query("select * from cats where id='".$cat[0]['cid']."' order by position");
$cat3 = $db->fetched_array();
$smarty->assign("cat",$cat3[0]);

$smarty->display("product.html");
?>