<?
include ("../_cms/classes/phplib/prepend.php");
echo "tab_f = new Array();";

$db2 = new DB__("select count(type.id_type) as ile, type_category.name from type 
left join type_category on type_category.id=type.id_type 
group by type.id_type");   //malejaco
while($db2->next_record())
{
     echo "tab_f['".$db2->f('name')."']=new Array(2); ";
     echo "tab_f['".$db2->f('name')."'][0]=new Array(".$db2->f('ile').");tab_f['".$db2->f('name')."'][1]=new Array(".$db2->f('ile')."); ";
}

$db = new DB__("select type.*, type_category.name as kind from type 
left join type_category on type_category.id=type.id_type 
group by type.id 
order by type_category.name, type.name");   //malejaco
$if=0;
if($db->nf())
{

     while($db->next_record())
     {
                echo "tab_f['".$db->f('kind')."'][0][$if]='".$db->f('name')."';";
                echo "tab_f['".$db->f('kind')."'][1][$if]='".$db->f('ico')."';";
                $if++;
     }
}
?>