CodeIgniter Forums

Full Version: Unknown column
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

Hi all,

I'm using the below code to update a table, pretty simple.

$review_pic_string = '1_' . $new_review_id . $orig_data['upload_data']['file_ext'];

//Update the atg_reviews table with the picture(s)
$this->db->set('pic_1', $review_pic_string , FALSE);
$this->db->where('review_id', $new_review_id);

I get the following error:

A Database Error Occurred
Error Number: 1054
Unknown column '1_341.jpg' in 'field list'
UPDATE `atg_reviews` SET `pic_1` = 1_341.jpg WHERE `review_id` = 341

I can't understand why 1_341.jpg' is consiered a column. Any ideas?

All help appreciated,

El Forum

re-read the page for db->set in the userguide. You're passing false as the third param which means don't escape things. You're sending a string to a varchar column guess what it needs to have done to it.

El Forum

That's it. I should have seen that. SOrry.