my $sth = $dbh->prepare(
                " 
                    select t.id,t.emp_name,t.emp_email,t.req_status,t.date_requested,t.mngr_email,t.date_submitted, 
                    ( SELECT 
                    GROUP_CONCAT( (case when req_status = 'Approved' then emp_name end) separator ', ') 
                    FROM requests s WHERE s.date_requested = t.date_requested) 
                    AS approved 
                    FROM requests t 
                    WHERE req_status = 'Pending'
                    AND mngr_email = '$filter'
                    AND date_requested >= '$date'
                    ORDER BY emp_name,date_requested
                "
            );

##</code><code>##

my $sth = $dbh->prepare(
                    " 
        INSERT requests ( emp_name, emp_email, emp_title, mngr_name, mngr_email, date_requested, req_status, date_submitted, approved_by ) 
    VALUES ( '$login_name', '$login_email', '$login_title', '$login_mngr_name', '$login_mngr_email', '$date', 'Pending', '$req_date', '' )
                    "
                        );