in reply to Problem with mysql query using DBI::Mysql

Have you tried peeking at $DBI::errstr to see if the execute() works as expected?

Also, I tend to use fetchrow_hashref() rather than fetchrow_array() because this lets me alter the table structure without fear of breaking anything.

  • Comment on Re: Problem with mysql query using DBI::Mysql