UsersController::update_tbl PHP Method

    function update_tbl()
    {
        $this->layout = 'none';
        $this->loadmodel('Easycase');
        $this->recursive = -1;
        $caseno = array(7, 8, 9);
        foreach ($caseno as $k => $v) {
            $res = $this->Easycase->query('SELECT *,MAX(id) AS pid ,MAX(dt_created) AS dt  FROM easycases WHERE case_no=' . $v . ' GROUP BY project_id');
            foreach ($res as $key => $val) {
                $sql = "UPDATE easycases set updated_by='SELECT user_id FROM easycases WHERE id=" . $val['0']['pid'] . " ',dt_created='" . $val[0]['dt'] . "'  WHERE case_no=" . $v . " AND project_id=" . $val['easycases']['project_id'] . " AND istype=1";
                $this->Easycase->query($sql);
                //echo $sql."<hr/>";
            }
        }
        echo "success";
        exit;
    }