in reply to I still haven't found any solution to DBD::mysql::st fetchrow_array failed: fetch() without execute()

Make your life easier with:

my $stmt="SELECT distinct name FROM storeCategories";
my $names = $dbh->selectrow_hashref($stmt, undef, $id);

[download]

and get a nice human readable hash. Required reading.

—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot
  • Comment on Re: I still haven't found any solution to DBD::mysql::st fetchrow_array failed: fetch() without execute()
  • Download Code

In Section Seekers of Perl Wisdom