This needs to be 2 queries, one to get the posts most recently commented like: $q = “SELECT wp_comments.comment_post_id, wp_posts.* FROM wp_comments LEFT JOIN wp_posts ON wp_comments.comment_post_id = wp_posts.ID ORDER by wp_comments.comment_date DESC”; And one to get the most 10 recent posts by add or edit: $q = “SELECT * FROM wp_posts WHERE post_type=”post” OR … Read more
First of all don’t use query_posts function, use the WP_Query class instead. Secondary you forget to fetch attachments for a post. You can get attachments list by calling get_children function. $args = array ( ‘post_type’ => ‘attachment’, ‘post_mime_type’ => ‘audio’, ‘numberposts’ => -1, ); $the_query = new WP_Query( ‘portfolio-tags=apple&post_type=portfolio&posts_per_page=-1&orderby=title&order=asc’ ); if ( $the_query->have_posts() ) : … Read more
You can filter ‘posts_fields’, check if it is the main query and limit the queried fields to … whatever you need. See WP_Query::get_posts() in /wp-includes/query.php for details and side effects. For debugging the queries I recommend the plugin Debug Bar. If you add … define( ‘WP_DEBUG’, TRUE ); define( ‘SAVEQUERIES’, TRUE ); … to your … Read more
$query = new WP_Query( ‘post_type=page’ ); as seen at codex http://codex.wordpress.org/Class_Reference/WP_Query#Type_.26_Status_Parameters
You can create a taxonomy.php file and put your loop/query inside this file and as such anytime you are on a taxonomy page, no matter the term, be it cranes, bulldozers, etc the taxonomy.php will take over and handle the term in question (as shown in your URL). Taken from the WordPress Codex, this is … Read more
i’m not sure what you are trying to achieve w/ the $paged variable. seems like you could simplify your query though $posts_per_page = is_paged() ? 5 : 2; $args=array( ‘post_type’=>’post’, ‘category_name’ => ‘featured-content’, ‘posts_per_page’ => $posts_per_page ); $temp = $wp_query; $wp_query= null; $wp_query = new WP_Query($args); edit, adding an offset (and fixing syntax errors): $paged … Read more
no idea what the problems actually are, but from looking at the code, I woud suggest: a: the while (have_posts()) : should be while ($the_query->have_posts()) : b: you would need to increment the counter: <?php $count = $count + 1; ?> c: the endif; of the loop might be missing after the endwhile; – at … Read more
Assuming each site is WP, they’ll both have RSS feeds. You’re better off just to fetch the RSS feed and get the latest post link from that. WP even has some built in support RSS parsing! <?php /** * An example of how to use fetch feed * * @uses fetch_feed * @return bool|string False … Read more
With pagination is easy 🙂 -just retrieve all the posts, then skip the first one out. At the end rewind back to the beginning of the loop and output the post you missed out. if( have_posts() ): while( have_posts() ): the_post(); if( 0 == $wp_query->$current_post ) continue; // Display all but the first post endwhile; … Read more
You don’t have to export and then re-import, you can do it all via the API in one go, no XML required. here’s a quick example plugin: <?php /* Plugin Name: WPA_convert_types */ function wpa_convert_types_page() { add_management_page( ‘WPA convert types’, ‘WPA convert types’, ‘manage_options’, ‘wpa_convert_types’, ‘wpa_convert_types_render_page’ ); } add_action(‘admin_menu’, ‘wpa_convert_types_page’); function wpa_convert_types_render_page() { if( isset( … Read more