openside("name");
$cat = 1;
echo "
";
$wynik = dbquery("SELECT * FROM ".DB_ARTICLES." WHERE ".groupaccess('article_cat_access')." AND article_draft='0' AND article_cat='$cat'
ORDER BY article_datestamp DESC LIMIT 1");
if(dbrows($wynik) > 0) {
$r = dbarray($wynik);
echo "
".THEME_BULLET." ".trimlink($r['article_subject'], 23)." |
".stripslashes(nl2br(trimlink($r['article_snippet'] , 70)))." |
".THEME_BULLET." Czytaj wiecej |
";
$wynik1 = dbquery("SELECT * FROM ".DB_ARTICLES." WHERE ".groupaccess('article_cat_access')." AND article_draft='0'
ORDER BY article_datestamp DESC LIMIT 1, 4");
while($r1 = dbarray($wynik1))
{
$itemsubject = trimlink($r1['article_subject'], 23);
echo "
".THEME_BULLET." $itemsubject |
";
}
$ile = dbcount("(article_id)", DB_ARTICLES, groupaccess('article_cat_access')." AND article_draft='0' AND article_cat='$cat'");
if ($ile > 10) echo "Czytaj Wiecej";
} else { echo "Brak artykulów"; }
echo "
";
closeside();