I have Projects inserted as posts in my WordPress database. currently on my home, the last 3 published project is displayed. now my purpose is that I want first display the project which is expiring today than the last published project.
for example, there are 2 projects are expiring today than on the home page it will display 2 projects which are expiring today and 1 project which published last. it means a total of 3 projects will display.
please check below WP_query which returns last published project only
$args = array('post_type' => 'ignition_product', 'posts_per_page' => $project_count, 'paged' => $paged); $newargs = apply_filters('project_query', $args); $wp_query = new WP_Query($newargs);
the below query I try using meta key & value but no luck. "ign_fund_end" is stored a date as a string so I think that's why not comparing date. my final goal is I described as above total 3 projects should display. first should be today expiring then after last published.
$args = array( 'post_type' => 'ignition_product', 'posts_per_page' => $project_count, 'paged' => $paged, 'meta_query' => array(// WordPress has all the results, now, return only the events after today's date array( 'key' => 'ign_fund_end', // Check the start date field 'value' => date('m/d/Y'), // Set today's date (note the similar format) 'compare' => '>=', // Return the ones greater than today's date 'type' => 'DATE' // Let WordPress know we're working with date ) ));
any solution appreciated.