An IN query is not a string comparison query. It is more like a bunch of OR statements. … WHERE tablename.animal IN (‘cat’,’dog’,’ferret’) is going to be the same as …WHERE tablename.animal=”cat” OR tablename.animal=”dog” OR tablename.animal=”ferret” $_POST[‘_casestudypost’] is going to be an array, and if you stored it as a single value in postmeta it … Read more
Read de Codex entry for user_register action, it says: Not all user meta data has been stored in the database when this action is triggered. Note that doing: $user = wp_insert_user( $userdata ); update_user_meta( $user, ‘companyId’, 350 ); Follow this sequence: insert user -> run user_register action -> rung your update user meta function. So, … Read more
You can run a loop through all your posts and change their meta value. To do so, create a plugin and run a loop upon its activation, using get_posts(): <?php /* Plugin Name: Update MetaData for Posts Description: Enable this plugin to update the metadata for all the posts Author: JackJohansson Version: 1.0 Author URI: … Read more
You forgot option 3 – Add a special table in which the pair (user,post id) will be the index. Ok I am not a MySQL person so maybe it is too extreme, but maybe having two tables one with users as index and one with posts will be even better. The thing about performance is … Read more
The get_pages function is rather old and really shouldn’t be used anymore. Use a get_posts instead (a Page is just a special type of Post): $listingPages = get_posts( array( ‘meta_key’ => ‘streetAdd’, ‘post_type’ => ‘page’, ‘post_status’ => ‘publish’, ‘orderby’ => ‘meta_value’, ‘order’ => ‘ASC’, ) );
You’re using $term->ID. Taxonomy terms do not have an ID property. They have a term_id property: $display_type = get_term_meta( $term->term_id ); You’ll notice that WooCommerce is using this, while your attempts are not.
For a left-sided match you can get around the automatic adding of ‘%’‘s by WP by using regular expression RLIKE: ‘meta_value’ => ‘^’ . preg_quote( $today ), ‘meta_compare’ => ‘RLIKE’ Similarly for right-sided match: ‘meta_value’ => preg_quote( $today ) . ‘$’, ‘meta_compare’ => ‘RLIKE’
take a look at the reference docs for the WP_Query class: http://codex.wordpress.org/Class_Reference/WP_Query something like this: $args = array( //some key/value pairs…whatever ‘meta_query => array( array( ‘key’ => somekey, ‘value’ => somevalue, ‘compare’ => some comparison operator ), array( ‘key’ => some other key, ‘value’ => some other value, ‘compare’ => some comparison operator ) ) … Read more
The goal was to paginate comments, showing comments with the highest comment_rating meta value first. Thanks to the answer of cjbj and the comments by Milo and birgire I figured out the rather unintuitive solution to the issue. By using numberand offset I was able to make the results in the proper order, but pagination … Read more
You might want to check out the query improvements in WP 4.2 for ‘orderby’ and ‘meta_query’. Details are on https://make.wordpress.org/core/2015/03/30/query-improvements-in-wp-4-2-orderby-and-meta_query. Try to name your meta_query clauses, then order by them. Following code is untested: $query = array( ‘order’ => ‘DESC’, ‘meta_query’ => array( ‘relation’ => ‘OR’, ‘cat1-clause’ => array( ‘key’ => ‘cat1’, ‘type’ => ‘numeric’ … Read more