openside("Kategorie");
$result = dbquery("SELECT * FROM ".$db_prefix."article_cats
WHERE article_cat_id=[color=red][b]1[/b][/color] ORDER BY article_cat_id");
if (dbrows($result)) {
while ($data = dbarray($result)) {
echo "".$data['article_cat_name']."
";
$result2 = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat='".$data['article_cat_id']."' ORDER BY article_datestamp DESC LIMIT 5");
while ($data2 = dbarray($result2)) {
echo "
".$data2['article_subject']."
\n";
}
}
}
closeside();