So, I have a loop that works great.
But I need to count how many posts that loop has, and I need to do it via a query to the DB.
My loop looks like:
$adsArg = array( 'offset' => $offset, 'post_type' => 'ads', 'meta_key' => $metaKey, 'tax_query' => $taxQuery, 'meta_query' => $metaValue, ); $adsQuery = new WP_Query($adsArg);
And the query I have so far looks like:
$wpdb->get_var($wpdb->prepare("SELECT COUNT(ID) FROM " . $table_name . " WHERE post_type = 'ads' AND post_status = 'publish' AND tax_query = " . $taxQuery . " AND meta_query = " . $metaValue . ", array() ) );
It's not working and I have no idea the proper way to do that.
The counter has to be done this way, with a direct query to the database.