You’re meta querying on serialized data. I mean the artist from ‘key’ => ‘artist’ is serialized. That’s why your meta query hasn’t work. So here is my possible solution- $projects = get_posts(array( ‘post_type’ => ‘project’, ‘meta_query’ => array( array( ‘key’ => ‘artist’, // name of custom field ‘value’ => ‘”%’ . $artist->term_id . ‘%”‘, ‘compare’ … Read more
You need to add the meta_compare argument to the meta query . Now your code will be like : ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘pb_responsible_home_person’, ‘value’ => $current_player_name, ‘compare’ => ‘=’ ), array( ‘key’ => ‘pb_responsible_away_person’, ‘value’ => $current_player_name, ‘compare’ => ‘=’ ), )// meta query end EDIT $current_player_name = get_post_meta( … Read more
There is an argument meta_compare. Use it for comparison. $args = array( ‘posts_per_page’ => -1, ‘post_type’ => ‘matches’, ‘meta_key’ => ‘date’, ‘meta_compare’ => ‘>’, ‘meta_value’ => ‘2016-11-12’, ‘type’ => ‘DATE’ );
As you said data is stored inside meta_value as serialized format. You can match your string among the serialized string like data. $args = array( ‘meta_query’ => array( array( ‘key’ => ‘submitted’, ‘value’ => sprintf(‘:”%s”;’, ‘vivek’), ‘compare’ => ‘LIKE’ ) ) ); $query = new WP_User_Query( $args ); Hope this help!
Save the user IDs found in the first query, as an array, before executing the second query. Then use that array in the exclude value, in the second query args and then run it. UPDATE How to put the IDs from the first query into an array, to be used in the second query. You … Read more
The problem is that you’re passing a meta VALUE in the key field of the meta_query…you should be passing your meta KEY there (“_wccf_pp_event_date”), as in: $seasons = array ( ‘spring’ => array (‘2017-03-21’, ‘2017-06-20’), ‘summer’ => array (‘2017-06-21’, ‘2017-09-20’), ‘fall’ => array (‘2017-09-21’, ‘2017-12-20’), ‘winter’ => array (‘2017-12-21’, ‘2018-03-20’), ) ; foreach ($seasons as … Read more
try : $users = new WP_User_Query(array( ‘s’ => $yoursearchquery, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘billing_last_name’, ‘value’ => $yoursearchquery, ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘billing_first_name’, ‘value’ => $yoursearchquery, ‘compare’ => ‘LIKE’ ) ) ));
Probably the date format should be different – like: $date_debut = date(‘Y-m-d’,$date_debut); $date_fin = date(‘Y-m-d’,$date_fin); I haven’t tested this but the doc says: The ‘type’ DATE works with the ‘compare’ value BETWEEN only if the date is stored at the format YYYY-MM-DD and tested with this format.
Querying wp_postmeta would be the way to go: global $wpdb; $results = $wpdb->get_col(“SELECT meta_value FROM $wpdb->postmeta WHERE meta_key = ‘quiz_results'”); That will get you an array of values for quiz_results across all posts.
A diamond question mark is browser for “I can’t decode that.” I would assume what is happening is when you migrated the HTML entity for space was encoded in your database wrong or WordPress is reading it with the wrong encoding assumed.