if (!defined("DB_ARTICLES")) {

define("DB_ARTICLES", DB_PREFIX."articles");

}



if (!defined("DB_ARTICLES_CATS")) {

define("DB_ARTICLES_CATS", DB_PREFIX."article_cats");

}



$kolumn = 3; 

$licznik =0;

$lista = 0;





openside("Kategorie");

$result = dbquery("SELECT * FROM ".DB_ARTICLES_CATS." WHERE article_cat_id IN (1,2,3) ORDER BY article_cat_id");



echo "<table cellpadding='0' cellspacing='0' class='center'>";





if (dbrows($result)) {

while ($data = dbarray($result)) {

 

if (++$licznik==1) echo "<tr>"; 

  			

echo "<td width='100' class='tbl'><b><a href='".BASEDIR."articles.php?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a></b><br><br>";		

$result2 = dbquery("SELECT * FROM ".DB_ARTICLES." WHERE article_cat='".$data['article_cat_id']."' ORDER BY article_datestamp DESC LIMIT 3");

while ($data2 = dbarray($result2)) {

   

  

   

echo "<a href='".BASEDIR."/readarticle.php?article_id=".$data2['article_id']."'>".$data2['article_subject']."</a><br>";







}



if ($licznik==$kolumn) { echo "</tr>"; $licznik=0; }

					

}



}



$koniec=$kolumn-count($lista)%$kolumn;

if ($koniec<>$kolumn) {

for ($i=0;$i<$koniec;$i++) {

$licznik++;

echo "<td> </td>";

}

if ($licznik==$kolumn) echo "</tr>";

}

echo "</table>"; 



closeside();