WordPress Dynamic Copyright Date in Footer

Your footer should display your copyright something along the lines of 2005 – 2011. Usually people only have the current year, or they have some time in the past because they haven’t updated it. Use this snippet to make the date dynamic so you don’t have to worry about it every again.

 
function comicpress_copyright() { 
 
global $wpdb; 
$copyright_dates = $wpdb->get_results("
SELECT
YEAR(min(post_date_gmt)) AS firstdate,
YEAR(max(post_date_gmt)) AS lastdate
FROM
$wpdb->posts
WHERE
post_status = 'publish' 
"); 
$output = ''; 
 
if($copyright_dates) { 
$copyright = "&copy; " . $copyright_dates[0]->firstdate; 
 
if($copyright_dates[0]->firstdate != $copyright_dates[0]->lastdate) { 
$copyright .= '-' . $copyright_dates[0]->lastdate; 
} 
$output = $copyright;
} 
 
return $output;
}

Then insert this into your footer: