<?
/******************************************************************************
 * MAIN
 *****************************************************************************/

include("../application.phtml");

setdefault($catid, 0);
setdefault($pid, 0);
setdefault($category_id, 0);
setdefault($catid1,0);

$qid_c = get_sub_categories($catid);
$qid_c1= get_sub_categories(1);
$qid_c2= get_sub_categories(2);
$qid_c3= get_sub_categories(4);
$qid_c4= get_sub_categories(5);
$qid_c5= get_sub_categories(6);
$qid_c6= get_sub_categories(8);
$qid_c7= get_sub_categories(3);
$qid_p = get_products($pid);

$DOC_TITLE = "Kashu Sales Catalog";
include("$CFG->templatedir/header.phtml");
include("templates/site_map.phtml");
include("$CFG->templatedir/footer.phtml");

/******************************************************************************
 * FUNCTIONS
 *****************************************************************************/

function get_sub_categories($catid=0) {
/* get the name and description of all the sub-categories under this one */

	$qid = mysql_query("SELECT id, name, description FROM categories WHERE parent_id = $catid AND id > 0");
	return $qid;
}

function get_products($category_id=0) {
/* get all the products under this category */

	$qid = mysql_query("
	SELECT
		 p.id
		,p.name
		,p.description
		,p.color
		,p.sku1
		,p.size1
		,p.sku2
		,p.size2
		,pc.category_id
	FROM
		 products p
		,products_categories pc
	WHERE p.id = pc.product_id
		AND pc.category_id = $category_id
	");

	return $qid;
}

?>