$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; } } }