You just need to add a DISTINCT to your SQL query, something like: $cities = $wpdb->get_col(“SELECT DISTINCT(meta_value) FROM $wpdb->usermeta WHERE meta_key = ‘my_cities_meta_key'” ); Alternatively, if you want to do it with php for some reason (if you want to know that a city is listed twice before displaying only unique entries) $cities = $wpdb->get_col(“SELECT … Read more
As @Milo suggested and also codex documented it is_main_query Under_the_Hood This function is an alias for the method WP_Query::is_main_query(). In filter or action hook callbacks that are passed the WP_Query object, such as pre_get_posts, it is circular to call this function. Instead, directly call the passed object’s method. For example, if your filter callback assigns … Read more
If you are storing your meta values as a single string separated by commas, you can use the native PHP explode() to store them in an array: $ct = get_post_meta($post->ID, ‘ct’, true); // Store them in an array $country_array = explode(‘,’ , $ct); // Run a loop and echo them foreach( $country_array as $key => … Read more
Ok, I found a solution. I first looped through and got all the child page ID’s, created an array, and used post_parent__in <?php $parentarray = array($parentid); $parentposts = new WP_Query( array( ‘posts_per_page’ => -1, ‘post_type’ => ‘page’, ‘post_parent’ => $parentid ) ); while ( $parentposts->have_posts() ): $parentposts->the_post(); ?> <?php $parentarray[] = get_the_id(); ?> <?php endwhile; … Read more
Based on our chat in the comments here’s what I came with. Please advise if it works. <?php function primary_category_query_shortcode( $post, $atts ) { //global $post; //Uncomment this global if it still doesn’t work. $atts = shortcode_atts( $defaults, $atts, ‘primary_category_query’ ); $my_meta = get_post_meta ( $post->ID, ‘_yoast_wpseo_primary_category’, true ); // WP_Query arguments $args = array … Read more
WordPress will serialize arrays when saving to post meta. The data stored under the key _employer_socials in your example looks like this: Array ( [0] => Array ( [network] => facebook [url] => # ) [1] => Array ( [network] => twitter [url] => # ) [2] => Array ( [network] => linkedin [url] => … Read more
I believe what you are looking for is the relation parameter in meta_query. I’m assuming you are using the WP_Query class to make the call given your syntax in the example. You might want to ensure that no other plugins are forcing the relation parameter to be “OR” instead of the default “AND” by hooking … Read more
I found solution by using type parameter in meta_query, set it to numeric. By default it is char and 1000 interpreted as string. ‘meta_query’ => array( array( ‘key’ => ‘wpcf-product-price’, ‘value’ => array(0, 1000), ‘type’ => ‘numeric’, ‘compare’ => ‘BETWEEN’, ), ),
post is not a valid value for orderby parameter neither DESC. You can choose any of these values. Also, you should stop using query_post. <?php $args = array( ‘post_type’ => ‘ranking’, ‘orderby’ => ‘menu_order’, ‘order’ => ‘DESC’, ‘posts_per_page’ => 10, ‘meta_key’ => ‘top10’, ‘meta_value’ => ‘sim’ ); $loop = new WP_Query( $args ); while ( … Read more
After some testing, I figured out the issue. With the Advanced Custom Fields plugin, you have to make sure your field name is unique in order for it to save properly. For some reason, I had another custom field name called ‘URL’ that was interfering with my ‘url’ custom field. After changing the name of … Read more