Didn’t test this but maybe this for Category ID=14
<?php
$post_count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id=14;");?>
<p><?php echo 'post count is ' . $post_count; ?></p>
it’s weird;
with the plugin, i have 5 for result
with the plugin and your code it’s 20
but i have 104 posts in the category :/
Darn, forget that as it will include revisions. Try this:
<?php
$mycats=get_categories ('include=14');
echo 'my cat count is '. $mycats[0]->category_count;
?>
i try this:
<div>
<p>
<?php
$mycats=get_categories ('include=14');
echo 'my cat count is '. $mycats[0]->category_count;
?> posts in this category.
</p>
</div>
but i have only the echo text, and no number 🙁
bye
Make sure you are using the correct category ID.
Hover over the Category Name in your Posts->Categories panel to ascertain the category ID.
Oh, i see,
this is my organization:
category_principal
—- cat 1
———cat 1.1
———cat 1.2
—- cat 2
———cat 2.1
———cat 2.2
so, it’s not possible to count the total number of posts directly on category_principal?
so, how to have many cat in “WHERE term_taxonomy_id=1” ?
bye 🙂
I try:
<?php
$post_count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id=14
AND WHERE term_taxonomy_id=1
AND WHERE term_taxonomy_id=2
AND WHERE term_taxonomy_id=3;");?>
<p><?php echo 'post count is ' . $post_count; ?></p>
but no result 🙁 is not the good syntax?
bye
Guess using my code above you could add the exclude parameter:
$mycats=get_categories ('include=14&exclude=5,7');
where 14 if the category id of principal and where 5 and 7 are the category ids of the cat 1.1 and cat 1.2.
sorry, doesn’t work, but i’m sure that is the correct id 🙁
So if you use wp_list_categories with those same parameters do you get the categories you want?
with:
<?php wp_list_categories('orderby=name&show_count=1&include=97&use_desc_for_title=0'); ?>
i have the error:
Warning: array_keys() [function.array-keys]: The first argument should be an array in /home/blog/wp-includes/taxonomy.php on line 1965
Warning: join() [function.join]: Invalid arguments passed in /home/blog/wp-includes/taxonomy.php on line 1965
Warning: Invalid argument supplied for foreach() in /home/blog/wp-includes/taxonomy.php on line 1972
Well that wp_list_categories works for me on a 2.7 blog but guessing you are using 2.6.5 (or a version close to that).
Could be something wrong your with database tables. Might try repairing you database tables, but backup your database before doing that.
i upgrade to wp 2.7 and i have no errors 🙂 but it’s only possible to calculate the number of posts of only one sub-category (example the cat 1.1) and not the principal category (example cat 1) 🙁
bye
re,
already no solution for calculate number of posts of a general category and the sub-category, in a same only one result? 🙁
bye.