Wordpress recently updated pages or posts

Here is some code I hacked together to display a list of recently updated pages and posts on a Wordpress site:


<?php
$today = current_time('mysql', 1);
$howMany = 18;
if ( $recentposts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND post_modified_gmt < '$today' ORDER BY post_modified_gmt DESC LIMIT $howMany")):
?>
<h2><?php _e("Recent Updates"); ?></h2>
<ul>
<?php
foreach ($recentposts as $post) {
if ($post->post_title == '') $post->post_title = sprintf(__('Post #%s'), $post->ID);
echo "<li><a href='".get_permalink($post->ID)."'>";
the_title();
echo '</a></li>';
}
?>
</ul>
<?php endif; ?>

The variable $howMany holds the number of items to display in the list. I used some code I found in a Wordpress theme I am using on some website, and modified it to help someone in need of this specific solution.

Update: I just added this code to the bottom of this website and configured it to show only five items.

6 Comments so far

  1. [...] goes to Corey for this awesome [...]

  2. Philip on September 4th, 2009

    Oh sweet … Ive been trying to do this for a while … Thanks for posting it have used it on my website.

  3. COMPUTELOGY on November 15th, 2009

    Hi,
    Is there any way to have such code for blogspot?
    Regards,

  4. Stupid WordPress Tricks | Serita on December 3rd, 2009

    [...] Source: Corey [...]

  5. [...] Source: Corey [...]

  6. [...] Source: Corey [...]

Leave a reply

 

Thanks for reading!

You like? Subscribe to my
RSS RSS feed
or

Sign up for email updates:

Some Recent Updates