Untitled

        $ben_name = $row['BENEFICIARY_NAME'];
        if($num == $row['ACCOUNT_NUMBER'] && $row['PAYMENT_DESCRIPTION'] == 'Isplata Provizije Ananas.rs'){
            $sql = "SELECT `beneficiary_name` FROM `split_breakdown` WHERE `split_group_id` = '".$row['split_group_id']."' AND `account_number` <> '".$row['ACCOUNT_NUMBER']."'";
            $result = Database::query($sql);
            if($result){
                $new_name = Database::fetchAssoc($result);
                $ben_name = $new_name['beneficiary_name'];
            }else{
                $ben_name = $row['BENEFICIARY_NAME'];
            }
        }
        if ($num == $row['ACCOUNT_NUMBER'] && strpos($row['PAYMENT_DESCRIPTION'], "dostave") !== false) {

            $ben_name = $row['source_merchant_name'];

            if ($ben_name == "" || $ben_name == null) {
                $sql = "SELECT `beneficiary_name` FROM `split_breakdown` WHERE `payment_purpose_code` like '" . $row['payment_purpose_code'] . "' AND `account_number` <> '" . $row['ACCOUNT_NUMBER'] . "'";
                $result = Database::query($sql);
                if ($result) {
                    $new_name = Database::fetchAssoc($result);
                    $ben_name = $new_name['beneficiary_name'];
                } else {
                    $ben_name = $row['BENEFICIARY_NAME'];
                }
            }
        }