if (!defined("DB_ARTICLES")) {

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

}



if (!defined("DB_ARTICLES_CATS")) {

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

}

openside("Kategorie");

$lp= 1;

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

if (dbrows($result)) {

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

echo "<b><a href='".BASEDIR."articles.php?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a></b><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 $lp++." <a href='".BASEDIR."/readarticle.php?article_id=".$data2['article_id']."'>".$data2['article_subject']."</a><br>\n";

}					

}



}



closeside();