Unknown column

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,

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.

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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.