<?php
global $prefix, $sitetema;

?> <div id="TabloAc">

<? global $prefix, $sitetema;
$sor = mysql_query("select * from ".$prefix."_urunler_kategori ORDER by id ASC");
$yaz = mysql_fetch_array($sor);
$kayitsayisi = @mysql_num_rows($sor);

$kat_adet = 0;
do {
++$kat_adet;
$ana_ad = $yaz["uKategori"];
$ana_id = $yaz["id"];

?>

<div id="UrunAnaKategori" span='<? echo $kat_adet ?>'> <a href="#"><? echo $ana_ad ?></a></div>


<?
global $prefix, $sitetema;
$urun_q = "SELECT alo_urunler.baslik as baslik,alo_urunler.id as id ,alo_urunler.aile_id as aile_id, alo_urunler.seo_link as seo_link,
alo_aileler.ad as aile_adi, alo_aileler.id as a_id
FROM alo_urunler LEFT JOIN alo_aileler ON (alo_aileler.id = alo_urunler.aile_id)
WHERE alo_urunler.ana_id ='$ana_id'";

$urun_q= mysql_query($urun_q);

$no=0;
while ( $kat= mysql_fetch_assoc($urun_q) ) {

++$no;

$aile_adlari[($kat["a_id"])] = " " . $kat["aile_adi"];

if(!isset($a_id) || $a_id== "-1") {//aile id belirtilmemisse veya eski bir sayfa ise => aile_id = 1 (Tasarım) yapılır
$a_id = 1;}


$aile_ad_default =@ $aile_adlari[$a_id];

// $solkat_ad =$kat["baslik"];
$solkat_id =$kat["id"];
$solkat_ad = ($kat["aile_id"] == "0") ? $kat["baslik"] : $kat["baslik"].$aile_ad_default;
//$solkat_ad = ($kat1["aile_id"] == "0") ? $kat1["ad"] : $kat1["ad"] . $aile_ad_default;

$aile_id = $kat["aile_id"];
$aile_adi = $kat["aile_adi"];
$Link = harfdonustur($solkat_ad);
$Link1 = harfdonustur($kat["seo_link"]."-$aile_ad_default-urunler.html");

?>
<div id="UrunListesi" span='<? echo $no ?>'>

<a href='<? echo $Link1?>'> <? echo $solkat_ad ?></a>



</a></div>


<? } ?>

<? }
while ( $yaz = mysql_fetch_array($sor) );
?>
</div>