[frobak]

I am having an issue with updating a MySql table using codeigniter.

Basically, its inserting 'img' the characters, into the table column 'progress' rather than the value of the variable ($progress).

This is so strange!

Here is my model:

PHP Code:

    public function update_course_progress($progress_data) {
        $course_id  = $progress_data['course_id'];
        $user_id   = $progress_data['user_id'];
        $progress = $progress_data['progress'];
        $status = $progress_data['status'];
    
        $update_data = array (
            'progress'  => $progress,
            'status'    => $status,
        );
        // perform update on the matching row
        $this->db->update('training_stats', $update_data, array('course_id' => $course_id, 'user_id' => $user_id));
    } 


So, the issue is with 'progress' instead of inserting the value of this variable it is inserting 'img'???

So, if i var_dump $update_data i get this:

   

PHP Code:

array(2) { ["progress"]=> string(2) "1a" ["status"]=> string(1) "i" } 


Which is correct:

And if i use the profiler in CI to get the db queries, this is what I get:

PHP Code:

     UPDATE `training_stats` SET `progress` = '1a', `status` = 'i'
    WHERE `course_id` = '8'
    AND `user_id` = '2'   


Which is correct.

So why is it inserting 'img' into the db instead of 1a.

The table structure for this column is VARCHAR(4).

Code:

    progress varchar(4) NOT NULL DEFAULT '0',

I'm not getting any errors, and if I input the query above directly into phpmyadmin it works fine?

What can be wrong?