Welcome Guest, Not a member yet? Register   Sign In
Unknown column
#1

[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


Messages In This Thread
Unknown column - by El Forum - 09-03-2009, 02:00 PM
Unknown column - by El Forum - 09-03-2009, 06:24 PM
Unknown column - by El Forum - 09-04-2009, 04:31 AM



Theme © iAndrew 2016 - Forum software by © MyBB