my $sql = 'SELECT name, display, active FROM comm_desk_widget_status WHERE user = ?'; my $href = $dbh->selectall_hashref( $sql, 'display', undef, 'admin' ); print_html( $href ); sub print_html { my $h = shift; foreach my $label (sort keys %{ $h } ) { my $html = "