Hi All,

Below is the tag for display subcategory by specific category ID, my problem is, how do i display total new links beside the subcategory, for example:

Subcategory1 (20 New)
Subcategory2 (5 New)
Subcategory3 (0 New)
Subcategory4 (8 New)

Tag for display subcategory specific by Category ID:
sub {
my $output;
my $cat_db = $DB->table('Category');
my $cat_id = '226';
$cat_db->select_options('ORDER BY Full_Name');
my $sth = $cat_db->select ( {'FatherID' => $cat_id}, ['Full_Name','Name'] );
while (my ($cat,$heading) = $sth->fetchrow_array) {
my $url = $cat_db->as_url($cat);
$output .= qq~$heading~;
}
return $output;
}


Please help and thanks so much.