localhost, попробуй так
$SubCatId = mysql_result(mysql_query("SELECT `id` FROM `lib` WHERE `refid` = '$catId' AND `type` = 'cat' ORDER BY `id` DESC LIMIT 1"), 0);
if($SubCatId)
{
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `lib` WHERE `refid` = '$SubCatId'"), 0);
}
echo $count;где $catId - ид категории (не подкатегории)