<?php //php 7.2.24
	include('cfg/db.php'); 
    ini_set('max_execution_time', '0'); 
    set_time_limit(0);
    //same code above
    ini_set('memory_limit','-1');
    
    $sql = "SELECT `customer_id` FROM `text_blast_birthday_record`";
    $tbbr_list = $db->sql_query($sql);

    foreach($tbbr_list AS $row){
        $customer_id = $row['customer_id'];

        $comp_deal_id = $db->select("SELECT `company_dealer_id` FROM `customer_dms` WHERE `customer_record_id` = '$customer_id' GROUP BY `customer_record_id`");

        $query = "SELECT `company_id`, `dealer_id` FROM `source_company_dealer` WHERE `id` = '$comp_deal_id'";
        $compdeal_query = $db->sql_query($query);
        foreach($compdeal_query AS $data){
            $update = "UPDATE `text_blast_birthday_record` SET `company_id` = '" . $data['company_id'] . "', `dealer_id` = '" . $data['dealer_id'] . "' WHERE `customer_id` = '$customer_id'";
            $db->sql_query($update);
        }
    }
?>