what would be the quickest/shortest way to turn the $album_idx = $dbh->selectall_arrayref() into just an array?

@album_idx = @{$dbh->selectall_arrayref()}

Update: also, you may put album_id in the url, and eliminate the first SQL query