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.
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.