The WHERE was just an aside. My real question is: What debugging have you done?

You can't just throw 100 lines of code out there and say "Hey, someone fix it."

My original question stands: Is it in the DB results? Or is it in your generation of the HTML? Is it even a Perl thing? Have you tried your query in SQLPLUS, or whatever database client goes with the database you're using?

xoxo,
Andy
--
<megaphone> Throw down the gun and tiara and come out of the float! </megaphone>