in reply to Problem with DBI and MySQL

Are you sure the variables $pickup, $pmonth, $pday, $pyear contain the data you expect they contain?

I once searched for hours to find an error in my code, only to discover that one of the variables was empty and that its database field did not accept "undef", so the whole insert did not go through.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

In Section Seekers of Perl Wisdom