You can simplify that by using $wpdb->get_var. $total = $wpdb->get_var( “SELECT COUNT( * ) AS total FROM tableA” ); echo “Total Records:” . $total; However, the code you’ve got should work– either version of it. I tested both. The only thing I notice is that the first version of the code should give you Array … Read more
wp_get_archive for category returning different URLs on different but similar sites
the change you require is a modification to your theme, it will take time and you might end up corrupting it if you are not comfortable working with WordPress, instead of that you can make a child theme for it and make whatever change you want inside it. A replacement and partial solution would be … Read more
Have you read the codex page Author Templates? There it states: when a viewer clicks on a link to a post author, by default he or she is taken to a page listing the posts from that particular author in chronological order This depends on having the correct links setup, which can be done with … Read more
Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet
Pass your information through prepare as in this example from the Codex: $metakey = “Harriet’s Adages”; $metavalue = “WordPress’ database interface is like Sunday Morning: Easy.”; $wpdb->query( $wpdb->prepare( ” INSERT INTO $wpdb->postmeta ( post_id, meta_key, meta_value ) VALUES ( %d, %s, %s ) “, array( 10, $metakey, $metavalue ) ) ); Your array should have … Read more
Correct way to get the ratings for individual authors. This is for the author.php page. If you want to display it elsewhere on your site, for example to show the number of likes for the currently logged in user, then use get_current_user_id( ‘ID’ ); in place of get_the_author_meta. <?php function author_rating_total() { $user_id = get_the_author_meta( … Read more
Using has_term() requires the name of the taxonomy as a parameter. References: has_term() does not return when term is assigned post? Function Reference/has term
File input returns null in theme options array
tl;dr; This is not possible with tax_query. A tax_query is a restriction of the results delivered, not used to order posts. You use the Order & Orderby Parameters for that. A little excursion into statistics This has to do with statistics and mathematics, as a taxonomy is a nominal scale, meaning it is just a … Read more