$counter = 10;
$result = dbquery("
SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC");
$data = dbarray($result);
if (dbrows($result) != 0) {
while($data = dbarray($result))
{
if ($data['news_cat'] == 23 && $counter >= 1)
{
$itemsubject = trimlink($data['news_subject'], 30);
echo "
$itemsubject
\n";
$counter = $counter - 1;
}
}
}