I need to calculate some dynamic CSS based on how many top level categories exist. (NOT how many posts are in a category, or how many categories a post belongs to… Nothing about posts at all, just how many top level categories there are) I am new to PHP, but I couldn’t find any WP … Read more
This question already has answers here: Count(*) vs Count(1) – SQL Server (14 answers) Closed 7 years ago. I often find these three variants: SELECT COUNT(*) FROM Foo; SELECT COUNT(1) FROM Foo; SELECT COUNT(PrimaryKey) FROM Foo; As far as I can see, they all do the same thing, and I find myself using the three … Read more
I’m looking to echo the number of posts per month since the blog began, and for months where there was no posts echo ‘0’. This is the output I want: January 1, February 3, March 8, April 3, … Any help would be great. Dave 3 Answers 3 So basically what you need to do … Read more
I have been searching high and low for a way to count the amount of results from a get_users query. Most of what I found is to count the total number of posts in a post query, but nothing for counting the total number of users in the get_users query. Can someone point it out … Read more
I can’t find if WordPress stores the number of items in a menu. Basically I need to find out how many items are in a menu to work out the percentage each item should take up in the header bar. Is there a function? Or is the best way to achieve this doing something with … Read more
wp_count_terms() counts the number of terms in a taxonomy but not the number of post that have those terms and I’ve found that wp_count_post() does not accept a taxonomy. So whats a guy gotta do to count the number of post in a taxonomy term? Example: Term: Apples Post: 89 (this is what I want … Read more
I have an sql select query that has a group by. I want to count all the records after the group by statement. Is there a way for this directly from sql? For example, having a table with users I want to select the different towns and the total number of users select town, count(*) … Read more
How can I select count(*) from two different tables (call them tab1 and tab2) having as result: Count_1 Count_2 123 456 I’ve tried this: select count(*) Count_1 from schema.tab1 union all select count(*) Count_2 from schema.tab2 But all I have is: Count_1 123 456 19 Answers 19
I’m trying to get the count of published posts in a custom post type for the current user (to display on a profile page). I found this here on the forums: <?php global $wp_query; $curauth = $wp_query->get_queried_object(); $post_count = $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->posts WHERE post_author=”” . $curauth->ID . “” AND post_type=”user_video” AND post_status=”publish””); ?> But, … Read more
How can I make the comment count on a post on my index page include comments that have been made on, in my case, individual gallery pictures that are included in the post? It seems that comments made on attachments like this aren’t counted using the standard WordPress comments functions. 1 Answer 1 A gallery … Read more
