or download this
my $sql = "SELECT UID, MONTHNAME(PostDate), YEAR(PostDate) FROM news O
+RDER BY PostDate DESC";
my $sth = $dbh->prepare($sql) ||
...
$sth->execute ||
die "Error executing: $DBI::errstr";
$rv = $sth->bind_columns($UIDholder, $indexmonths, $indexyears);