Counting Posts by Category

0
down vote
accepted

I think it would help you to read this => http://wordpress.org/support/topic//display-number-of-posts-per-category

function number_postpercat($idcat) {
    global $wpdb;
    $query = "SELECT count FROM $wpdb->term_taxonomy WHERE term_id = $idcat";
    $num = $wpdb->get_col($query);
    echo $num[0];

}

Related Posts:

  1. How do I insert a after every 5 posts in a WordPress Loop that infinitely loads posts?
  2. Echo the number of posts being displayed
  3. Should we trust the post globals?
  4. How to mark every 3rd post
  5. Get first post from wp_query
  6. How to cache a shortcode functions output?
  7. Querying post from a multisite network
  8. How to query serialized array by comparing greater than (>=)?
  9. How to know if get_posts() failed?
  10. Show related posts by category but ignore one category
  11. post__in for get_posts with a dynamic array
  12. Query posts distinct authors
  13. Count singular post views automatically
  14. Set font size automatically according to number of words in post
  15. Post content being duplicated by the_content();
  16. Specific loop in Shortcode
  17. Sort posts by activity date
  18. How to add padding between posts
  19. Working Bootstrap Carousel Conversion to WP – Technical Questions
  20. Search widget breaks when using multiple loops?
  21. How to change bulk post status
  22. Add few specific post ids to wp_query
  23. WP_Query posts_per_page ignored
  24. wp_query ‘s’ parameter does not work with custom post type
  25. WP Query related posts by current page Tag ID
  26. WP_Query get posts from custom posts by category
  27. Accessing post->ID outside of the loop for listing child pages
  28. WP Query – duplicated posts once including tags in search results
  29. Reset Popular post query?
  30. Query Posts multiple conditions
  31. how to get posts ids inside pre_get_posts filter?
  32. Future post ID not showing
  33. How do I use WP_Query to get a range of posts with custom fields that have numbers with letters in them?
  34. recent posts for different categories
  35. Search by post title and content in wp_query without order
  36. Change post order random through out the entire WordPress
  37. Setup a custom dynamic post
  38. Anyway to grab author name and featured image in an embeded in inital array of posts outside of loop?
  39. Removing noindex posts from wp_query
  40. How safe is renovating $wp_query when doing WP_Query pagination in Page Template
  41. Exclude the first ‘n’ number of posts of a tag from home page?
  42. wp_posts table: safely remove unused columns to save database storage
  43. Using wp_list_pages() after calling query_posts()
  44. how to get post order by post id wp_query?
  45. Possible to alternate between two loops
  46. How to add category post count in main navigation menu [closed]
  47. How to display all posts divided/ordered by post date? [closed]
  48. Why are my paginated posts always returning the same results?
  49. Is it possible to use WP_Query to only pull posts with attachments?
  50. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  51. Counter is skipping post when I still want it visible [closed]
  52. Query posts by Author and/or by Tag
  53. Can’t understand why sometimes a [caption] field appears
  54. Why in my query is display two title?
  55. Migrate posts from category and sub-category via SQL
  56. wp_query with ajax
  57. Exclude some posts from displaying in wp_query based on some condition
  58. How to convert query sql to shortcode in wordpress?
  59. Use posts_where to exclude posts ids from wp_query
  60. Why does WordPress search returns same number of results for every search query?
  61. Sidebar limiting to 10 posts?
  62. WP_Query get posts in custom database table [duplicate]
  63. WP query taxonomy optimization
  64. Override WordPress core post-template.php block template
  65. Change Old WordPress Post Date Year
  66. Author post count in category
  67. Displaying all posts from other sites on the network on one site
  68. Display/Filter post using if else statement
  69. Search results for ACF data
  70. Multisite how to display merged posts from two sites and sort by latest date?
  71. Query prints posts without specific categories
  72. Numbered Pagination Showing The Same Posts After Altering WP_Query
  73. Show post count in custom taxonomy page
  74. Count singular post views automatically
  75. How to count posts in tags within time limit
  76. Using a meta_value or postdate to to query and orderby
  77. Exclude posts in home slider from sections
  78. Override wp_link_pages pagebreak with filter
  79. Retrieve posts inside foundation tabs and tab-content split by 3 per row
  80. Loop through all posts showing duplicates
  81. WP_Query extended with AJAX
  82. Manipulate query to show specific post
  83. WordPress text field in array problem
  84. Random order of the 5 most popular posts
  85. My custom query is displaying random posts in random order
  86. Get query result according to merged array
  87. Blog only showing one post even though more published
  88. Sort / Filter Queries
  89. How to show the posts list into a static page? Problems to use the loop into a static page
  90. How do I control the fallback query after the original query returned cero posts?
  91. Order posts by separate menu order for different sub-categories
  92. Displaying Results From Custom Taxonomy Query
  93. Multiple loops on a Search result page?
  94. WP_Query: Fetch posts that are in (category1 and not in category2), OR posts that are not in cagegory1
  95. Exclude sub sub categories from displaying in the archive page
  96. How do I show the post title if an advanced custom field hasn’t been used?
  97. Adding Count Post in Page
  98. How add class the_content();?
  99. Get related posts matching most of the provided tags using WP_Query
  100. WP_Query post_tilte search in posts table