Try following codes: $country_search_array = array(); while($row = mysql_fetch_array($regionresult)){ $country_search_array[] = $row[‘country’]; // Your country field name } $country_search = “‘”.implode(“‘,”, $country_search_array).”‘”; $args = array( ‘posts_per_page’ => -1, ‘meta_query’ => array( array( ‘key’ => ‘Country’, ‘value’ => $country_search, ‘compare’ => ‘IN’ ) ) ); $query = new WP_Query( $args );
Answering my own question, as suggested in my edit I’ve had to use the following meta_query array to query the posts: ‘meta_query’ => array( array( ‘key’ => ‘country’, ‘compare’ => ‘LIKE’, ‘value’ => ‘”‘ . get_the_ID() . ‘”‘ ) )
Instead of a new WP_Query, use the pre_get_posts filter add_filter(‘pre_get_posts’, ‘custom_query’); function custom_query($query) { if($query->is_main_query() && $query->is_author() && $_GET[‘eco’]==’somemetakey’) { $query->set(‘meta_query’, array( array( ‘key’ => ‘somemetakey’, ‘value’ => $query->get(‘author’) ) )); } }
I agree with @Simon Blackbourn, but for arguments sake, here’s one technique: $data = get_user_meta( $user_id ); $data = wp_list_filter( $data, array( ‘ive-read-this’ ) ); $keys = array_keys( $data );
Ok, I think I found something that actually works, and I’m posting it just in case someone need it. The solution is simply to avoid using Pagenavi just for this page, using paginate_links() instead and forcing it to behave more or less like Pagenavi to maintain coherence all over the site. Let me explain. My … Read more
You’ll need to use meta_query along with meta_(key|value|compare) to interact with two different keys and get the order you want. <?php $q = new WP_Query(array( ‘post_type’ => ‘my_project’, ‘nopaging’ => true, // same as posts_per_page => 1, ‘order’ => $order, ‘orderby’ => ‘is_featured_position’, // your position key here ‘meta_key’ => ‘is_featured_position’, // also here, see … Read more
Your current query will select posts that have a value in the key event_announced which does not equal on. What I think you want is NOT EXISTS, and you can omit value, since you are querying for posts that don’t have the key, hence, it will have no value. Note that NOT EXISTS is only … Read more
… I will need to be more specific, by adding a “%” after $author (James). The problem is that this will not work at all. Any idea why? The % is a wildcard with a MySQL LIKE query, which I suspect you know. With meta queries, WordPress will add one to the beginning and one … Read more
I know how to do that in pure SQL but I can’t get WP_Query to nest conditions in the way required. If it is acceptable, the easiest way to make this work would be to assign an arbitrary far future end date when the data is saved to the database. Something like strtotime(“2038-01-01”). That is … Read more
I was unable to create a WP_Query – I believe it is not possible to solve this using a regular WP_Query – but managed to create an SQL statement that does exactly what I want: SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id) … Read more