<?php $timelimit=1 * 86400; //days * seconds per day $post_age = date(‘U’) – get_post_time(‘U’); if ($post_age < $timelimit) { echo ‘this post is within my time limits ‘; //DO SOMETHING } ?>
You could do that with a custom posts_orderby: add_filter( ‘posts_orderby’, ‘wpa58715_posts_orderby’ ); function wpa58715_posts_orderby( $orderby_statement ) { if ( is_post_type_archive( ‘article’ ) ) { global $wpdb; $orderby_statement = “FIELD($wpdb->posts.post_author, 42) DESC, $wpdb->posts.post_author”; return $orderby_statement; } } Swap in your author ID for 42.
Edit: I believe my comments below are still valid, but I suspect part of the problem is the ‘relation’ => ‘OR’, This should be ‘AND’ (it’s default value,so it can be removed) to ensure that it only returns posts which satisfy both conditions. Currently it will return events that start, or end, after yesterday. In … Read more
Thats code just querying the posts by sorting it by meta value, but you have no loop for the posts to display. Add the loop after the query for something like this: echo ‘<ul>’; if ( have_posts() ) : while ( have_posts() ) : the_post(); echo ‘<li>’; the_title(); echo ‘</li>’; endwhile; endif; echo ‘</ul>’;
I think if you add a couple of periods before and after the php variable in your query, remove the use of mysql_fetch_array, and use get_row(), it should work better. Here’s how I would get a park from your custom table: <?php $page_title = wp_title(”); $park = $wpdb->get_row(“SELECT * FROM $wpdb->park_data WHERE park_name=””.$page_title.”””); if($park) { … Read more
Think about what you’re doing here. You’re hooking into the time which WordPress is saving a post. You need to use get_post_meta() to check if the saving post has that required meta key. If you get nothing back, or get_post_meta() returns false, then you need to add your post meta for this saving post using … Read more
Gladly there’s a function that will output exactly that query string for you (still laughing about it 🙂 ). Here it is: get_posts_by_author_sql @queryposts.com, which looks in the core source like this. In detail it builds the WHERE part for you, that you can drop into your query. So just throw the user ID in … Read more
Your date format is wrong, MySQL date format is yyyy-mm-dd. Once you get that fixed, see WP_Query‘s meta_query, no need for raw SQL in this case.
taxonomy & term won’t be set (in this case), since query vars are mapped from GET/POST. In other words, $qv[‘large_feature’] = 291 (see wp_edit_posts_query() and WP_Query::get_posts() for the big picture). add_filter( ‘parse_query’,’convert_large_feature_id_to_taxonomy_term_in_query’ ); function convert_large_feature_id_to_taxonomy_term_in_query( $query ) { global $pagenow; $qv =& $query->query_vars; if ( $pagenow == ‘edit.php’ && isset( $qv[‘large_feature’] ) && ctype_digit( $qv[‘large_feature’] … Read more
pre_get_posts runs on every query, so you want to check if is_main_query() so it only applies to the default query and not additional queries you run on the page. You should also get in the habit of referencing the query object passed to the function like $query->is_category(), as calling is_category() is a wrapper for $wp_query->is_category(), … Read more