The code you posted ...

• does not compile
• lacks use strict; and use warnings;
• is not properly indented
• does not use placeholders in SQL
• may have $lastmonth set to nonsense values
• uses the same variable $sth for two different statement handles (that may work because of different scopes)

You should repair those problems first.

Alexander