First, nice piece of work. A couple of comments:

1. Setting $FilesFound to 'Y' or 'N' isn't doing what you seem to expect it to. Logical tests of $FilesFound will always be true. Use 0 and 1 instead.
   
   
2. You're going to run into trouble the first time you hit an album name that has quotes in it. You can avoid this by using bind variables in your SQL queries, and pass the actual arguments to prepare(). Let MySQL do the quoting for you.
   
   
3. Setting RaiseError=1 when you connect might save you some SQL debugging grief.
   
   
4. A slight stylistic nit. return isn't a function call. I find it clearer to write   return @returnlist; than to write   return(@returnlist); which, on a quick skim, is easy to miss if one is focusing on control flow. This is a point on which reasonable people disagree.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.