quick wp stuff

gistfile1.php

<?php
funcion get_years(){
	$results = $wpdb->query("SELECT DISTINCT YEAR(meta_value) as year FROM wp_postmeta WHERE meta_key = 'release_date'");
	echo '<select>';
	foreach($results as $result){
		echo '<option>'.$result->year.'</option>';
	}
	echo '</select>';
}

function get_posts_by_year($year){
	$query = "SELECT post_id FROM wp_postmeta WHERE meta_key = 'release_date' AND YEAR(meta_value) = '".$year."'";
	$results = $wpdb-query($query);
	foreach($results as $result){
		$post = get_post($result->post_id);
		echo $post->post_title;
	}
}

get_posts_by_year($_GET['year']);

?>