$module = "catalog";
$sagmenu = "1";
$title = "Treading Area - Home Page";
include "../header.php";
?>
//$SubCatQuery = mysql_query("select SubId, CatId, SubCatName from subcategories order by CatId, SubCatName");
$SubCatQuery = mysql_query("
select c.SubId, c.CatId, c.SubCatName, count(u.id) as urun_say
from subcategories c, urun u, members m, country x
where u.sektor = c.SubId
and m.id = u.fid
and x.CountryId = m.country
group by c.SubCatName
order by c.SubCatName");
$SubCatCount = mysql_num_rows($SubCatQuery);
$SubId = Array();
$SubCatId = Array();
$SubCatName = Array();
$SubSay = Array();
for ($Si=0; $Si < $SubCatCount; $Si++) {
$S = mysql_fetch_array($SubCatQuery);
$SubId[$Si] = $S['SubId'];
$SubCatName[$Si] = $S['SubCatName'];
$SubCatId[$Si] = $S['CatId'];
$SubSay[$Si] = $S['urun_say'];
}
?>
$deneme = 0;
$CategoryQuery = mysql_query("select c.CatId, c.CatName from categories c group by c.CatName order by c.CatName");
$CategoryCount = mysql_num_rows($CategoryQuery);
for ($Ci=0; $Ci < $CategoryCount; $Ci++) {
$Cat = mysql_fetch_array($CategoryQuery);
if (in_array($Cat[CatId], $SubCatId, true)) {
if ($MainCat == $Cat['CatId']) { $kategori_rengi = "style='background: f1f1f1'"; } else { $kategori_rengi = ""; }
if ($deneme == "0") { echo "\n"; }
echo " ";
if (ceil($SubCatCount/2) <= $deneme) { echo " | \n"; $deneme=0; }
//echo $deneme;
} //array_key_exists
}
?>
|
include "../footer.php";
?>