[PHP] pobierz, plaintext 
<?php
$wynik = dbquery("SELECT article_cat, article_subject, article_cat_name, article_id, article_cat_id FROM ".DB_ARTICLES." a LEFT JOIN ".DB_ARTICLE_CATS." c ON (a.article_cat=c.article_cat_id) WHERE ".groupaccess('article_cat_access')." AND a.article_draft='0'");
if(dbrows($wynik) > 0) {      
$kategorie = array(); 
while($r = dbarray($wynik))    
{ 
if (!isset($kategorie[$r['article_cat_id']])){ 
$kategorie[$r['article_cat_id']] = array(
'article_cat_id' => $r['article_cat_id'], 
'article_cat_name' => $r['article_cat_name'], 
'articles' => array()); 
}
if (!empty($r['article_id'])) { 
$kategorie[$r['article_cat_id']]['articles'][] = array(
'article_id' => $r['article_id'], 
'article_subject'=>$r['article_subject'], 
'article_id'=>$r['article_id'],
'article_cat'=>$r['article_cat']); 
}
}
}
foreach ($kategorie AS $idCat => $category){
$article_cat_name[$idCat]  = $category['article_cat_name'];
echo "<div class='klik' id=".$category['article_cat_id']." style='text-align:left'>".THEME_BULLET." ".$category['article_cat_name']."</div>";  
foreach ($category['articles'] AS $articles){
echo "<div class=pokaz".$articles['article_cat']." style='text-align:left; margin-left:15px; display:none'>".THEME_BULLET." <a href='".BASEDIR."articles.php?article_id=".$articles['article_id']."'>".$articles['article_subject']."</a></div>"; 
} 
}
?>
[PHP] pobierz, plaintext