in reply to Problem with mysql query using DBI::Mysql
Also, I tend to use fetchrow_hashref() rather than fetchrow_array() because this lets me alter the table structure without fear of breaking anything.