Im looking to count how many meta keys exist within a post, because each time a specific user action happens, a new meta key is created with a date in it.
I have this, which does not return anything (I'm looking for a number)...
... $post_title = $row->post_title; $id = $row->ID; $post_count = $wpdb->get_var(" SELECT COUNT(DISTINCT $wpdb->postmeta.meta_key) FROM $wpdb->posts LEFT JOIN $wpdb->postmeta WHERE $wpdb->posts.post_type = 'things' AND $wpdb->postmeta.meta_key = 'dates' AND post_id = $id "); echo $post_title . ' (' . $post_count . ')' . "\n"; }
Similarly, I'd like to count the number of meta keys in total related to a custom post, any help on either of these would be greatly appreciated!