in reply to bind_columns error

Actually provide a list of references:
$rv = $sth->bind_columns( \($UIDholder, $indexmonths, $indexyears) );
Or don't declare them at the top, just declare them during the call:
$rv = $sth->bind_columns( \my ($UIDholder, $indexmonths, $indexyears) +);