Hi, I currently have the following code which displays perfectly the number of k2 items/articles within a category.

<?php
$cat_id = $this->item->category->id;
$db = JFactory::getDBO();
$select = "SELECT COUNT(*) FROM #__k2_items WHERE catid = $cat_id";
$db->setQuery($select);
$noitems = $db->loadresult();
echo $noitems;
?>

But the only problem is this includes unpublished items, therefore I need to modify this to only count 'Published' k2 items/articles.

Any help would be very much appreciated! Many thanks in advance!

In the query you need to add this parameter -> AND published=1