Kategoriler'; $yay_tip_sec=mysql_query("select yay_tip_id, yay_tip_ad from tbl_trcine_yay_tip order by yay_tip_ad asc"); while($yay_tip=mysql_fetch_row($yay_tip_sec)): $yay_say_sec=mysql_query("select count(yay_id) from tbl_trcine_yay where yay_tip='$yay_tip[0]'"); $yay_say=mysql_fetch_row($yay_say_sec); echo ''.unhtmlentities($yay_tip[1]).' ('.$yay_say[0].'adet)
'; endwhile; ?>
Yayın Adı İndeksi'; $ad_sec=mysql_query("select distinct(yay_ad) from tbl_trcine_yay order by yay_ad asc"); while($ad_yaz=mysql_fetch_row($ad_sec)): echo ''.unhtmlentities($ad_yaz[0]).'
'; endwhile; ?>
Yazar Adı İndeksi'; $yazar_sec=mysql_query("select distinct(yay_yazar) from tbl_trcine_yay order by yay_yazar asc"); while($yazar_yaz=mysql_fetch_row($yazar_sec)): echo ''.unhtmlentities($yazar_yaz[0]).'
'; endwhile; ?>