In general WordPress posts do not represent continuous process. They and their data capture the state of certain point in time (last edit). While there is a WP Cron mechanism for scheduled and (optionally) recurrent operations, it’s poorly suited for periodic post manipulation. For a large amounts of posts it would take either excessively long … Read more
Those are the old style meta query arguments. You should use meta_query instead, which will allow querying on multiple meta keys with conditions and nesting. See the Custom Field Parameters section in WP_Query for examples.
How to get meta value based on latest post id with group by term name
Post from front end form to post_meta
Create a Gallery and update Post Parent of Attachment Images
I guess you want to delete all meta values from all posts with this: delete_metadata(‘post’, null, $meta_key, null, true) See the documentation which says, that the last argument is ment to delete all entries from all objects: delete_metadata($meta_type, $object_id, $meta_key, $meta_value=””, $delete_all = false) $delete_all (boolean) (optional) Optional, default is false. If true, delete matching … Read more
Problem saving meta data
To use the LIKE comparison, try a string: $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘meta_query’ => array( array( ‘key’ => $user_key, ‘value’ => ‘followed’, // String here ‘compare’ => ‘LIKE’, ), ), ); return get_posts($args); Also, you can use WP_Query to help you debug: $args = array( ‘post_type’ => ‘post’, ‘post_status’ => … Read more
Why not pull the post you need, rather than pull a post and then check the value of the meta key? $now = strtotime(date(‘d-m-Y H:i:s’)); // get current timestamp $args = array( ‘post_type’ => ‘presenter’, ‘posts_per_page’ => ‘1’, ‘order’ => ‘DESC’, ‘meta_query’ => array( array( ‘key’ => ‘on_air’, ‘value’ => $now, ‘compare’ => ‘>=’, ), … Read more
Why are you using SQL when there is our Codex! Use this code snippet instead- function pre_change_query( $wp_query ) { $wp_query->set(‘meta_key’, ‘package_id’); $wp_query->set(‘orderby’, ‘meta_value’); $wp_query->set(‘order’, ‘DESC’); // or ‘ASC’ } add_filter(‘pre_get_posts’, ‘pre_change_query’); $args = array( ‘post_type’ => ‘estate_agent’, ‘posts_per_page’ => 10 ); $my_custom_query = new WP_Query( $args ); See Codex for details: https://codex.wordpress.org/Class_Reference/WP_Query