if ($id[0] eq "")
{   
    my $sql = "SELECT DISTINCT id FROM mytable WHERE active = ?";
    $id[0] =  @{$dbh->selectall_arrayref($sql,undef,'no')};
    #@id = map{ $_->[0] } @$ref;
    print join (", ", @id), "\n";
}