Hello Alex!

I need your advice as to how to export the data with category name instead of IDs. The following is what I am trying to insert in the sub_routine of export_data in DBSQL.pm!

while ($arr = $sth->fetchrow_arrayref) {
##################################################
if ($arr{'CategoryID'}) {
$arr{'CategoryID'} = &get_category_name ($arr{'CategoryID'});
}
###################################################
foreach (@$arr) {

May be there is something missing. Can you help?

Thanks in advance.