How to: Display recently updated posts and pages

Ever wanted to be able to display posts and page that have been updated recently? If yes, here’s a nice recipe, provided by Corey, that will get the things done.

Paste this code anywhere you'd like to display a list of recently updated posts and pages. You can specify how much item to show by editing the value of the $howMany variable.

<?php
$today = current_time('mysql', 1);
$howMany = 5; //Number of posts you want to display
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; ?>

Credits goes to Corey for this awesome code!