[eluser]webnology[/eluser]
Hi all,
I'm using the below code to update a table, pretty simple.
Code:
$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);
$this->db->update('atg_reviews');
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,
M