In the WP Docs you can find the answer. I have not tested this snippet, but it should become something like this: $args = array( ‘post_type’ => ‘product’, ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘key’ => ‘product-ean’, ‘value’ => 123, ‘compare’ => ‘=’, ), array( ‘key’ => ‘item-ean’, ‘value’ => 123, ‘compare’ => ‘=’, … Read more
How to mark only one post as Featured post?
Take a look at https://developer.wordpress.org/reference/classes/wpdb/get_col/ On your result page, receive the query as follows <?php if(isset($_POST[‘name’]) || isset($_POST[’email’])){ $name=”%” . $wpdb->esc_like( $_POST[‘name’] ) . ‘%’; $email=”%” . $wpdb->esc_like( $_POST[’email’] ) . ‘%’; global $wpdb; $prepare = $wpdb->get_col( $wpdb->prepare( ” SELECT post_id FROM “.$wpdb->prefix.”postmeta AS M WHERE M.meta_value LIKE ‘%s’ OR M.meta_value LIKE ‘%s’ “, $name, … Read more
ACF stores it’s dates in Ymd format, this is why i couldn’t compare. Make sure your date is in Ymd format when you compare it against an ACF datefield.
I’ve quickly tested the below code with a small subset of sendouts ( 3 ) and changing the publishing date of my page that uses this template it works fine <?php /** * Template Name: show sendouts template * */ get_header(); global $wpdb, $post; $curDate=strtotime(date(‘Y-m-d H:i:s’)); $postDate=strtotime($post->post_date); $pageAge=($curDate-$postDate) / (60 * 60 * 24); // … Read more
Check for not NULL not working in meta query
How to select meta key in custom database query
Get label in user meta query
meta_query check multiple date formats
Orderby if between two meta fields