Display a list of categories and number of posts in each

Create a block with a list of categories and post count next to each, like in this example:
* Illustrator (35)
* InDesign (44)
* Photoshop (178)
* Quark XPress (4)

<?php
  if (user_access('access content')) {
    $result = db_query("SELECT term_data.tid, term_data.name, COUNT(*) AS count FROM {vocabulary_node_types} INNER JOIN  {term_data} USING (vid) INNER JOIN {term_node} USING (tid) INNER JOIN {node} USING (nid) WHERE node.status = 1 and vocabulary_node_types.type = 'blog' GROUP BY term_data.tid, term_data.name ORDER BY term_data.name");
    $items = array();
    while ($category = db_fetch_object($result)) {
      $items[] = l($category->name .' ('. $category->count .')', 'taxonomy/term/'. $category->tid);
    }

    return theme('item_list', $items);
  }
?>

Comments

Drupal 6

barrandow commented 5 June 2009 at 19:33

In Drupal 6 just retype "blog" to "story":
...vocabulary_node_types.type = 'story'...

I'm getting the same error as Chillz

Daronna commented 29 May 2011 at 17:47

Hi
I'm getting the same error as Chillz.
PHP is enabled
I have followed all the instructions and get the error.

Has anyone found a solution to this problem?
Is there a step I am missing?

I also tried it with "westwesterson's" code and get the same error.

Thanking anyone in advance
Daronna

This worked for me in drupal

westwesterson commented 1 September 2009 at 00:56

This worked for me in drupal 6.13, make sure that you have php input filter enabled.

Also I tweaked this script slightly so that it would list terms by the count of taxonomy items. And limited to 25 terms.

  if (user_access('access content')) {
    $result = db_query("SELECT term_data.tid, term_data.name, COUNT(*) AS count FROM {vocabulary_node_types} INNER JOIN  {term_data} USING (vid) INNER JOIN {term_node} USING (tid) INNER JOIN {node} USING (nid) WHERE node.status = 1 and vocabulary_node_types.type = 'story' GROUP BY term_data.tid, term_data.name ORDER BY count desc LIMIT 25");
    $items = array();
    while ($category = db_fetch_object($result)) {
      $items[] = l($category->name .' ('. $category->count .')', 'taxonomy/term/'. $category->tid);
    }

    return theme('item_list', $items);
  }

Catagories should now show up as:
* Photoshop (178)
* InDesign (44)
* Illustrator (35)
* Quark XPress (4)

How can we also show the

manoz_79 commented 5 July 2010 at 09:47

How can we also show the number of comments the term has in the nodes tagged with it.

There's a Taxonomy block

espirates commented 3 October 2009 at 07:33

There's a Taxonomy block module that does this perfectly

It works nice for me on

Sinan Erdem commented 25 October 2009 at 12:24

It works nice for me on Drupal 6.14. But I was wondering instead of terms, can I show number of nodes in a whole vocabulary?

I mean instead of:
Austria(5)
Angola(2)
Australia(8)

I need:
Countries(15)

I have just found a solution

Sinan Erdem commented 25 October 2009 at 12:32

I have just found a solution if anyone needs:

<?php

  $output = '';
  foreach(taxonomy_get_vocabularies() as $vocab) {
    $term_count = db_result(db_query("SELECT count(*) FROM {term_data} WHERE vid = %d", $vocab->vid));
    $output .= '<h4>' . $vocab->name . '</h4><p>Total ' . $term_count . ' terms.<br/>';
 
  print $output;
?>

hello. I use the drupal 6.15

ksteo commented 28 February 2010 at 16:43

hello. I use the drupal 6.15 with easyphp 5.3 and also i have enable the php code. When i run the above code i get the message
Parse error: parse error in C:\Program Files\EasyPHP5.3.0\www\drupal\includes\common.inc(1685) : eval()'d code on line 3
Any help is wellcome
thanks

--Kostas--