[eluser]cmgmyr[/eluser]
Hello all,
I've been having a problem with the update_string function and I can't seem to find the problem.
I have:
Code:
$data = array('location' => $location,
'student_provider' => $student_provider,
'profession' => $profession,
'employer' => $employer,
'college' => $college,
'year_started' => $year_started,
'bio' => $bio,
'gender' => $gender,
'dob' => $dob,
'interests' => $interests,
'family' => $family,
'awards' => $awards);
$this->db->query($this->db->update_string('users_profile', $data, "id = ".$this->db->escape($id)));
And I'm getting the following error:
Code:
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a small section where I can fill out things about my interests., `family` = This' at line 1
UPDATE `users_profile` SET `location` = 'Test, NY', `student_provider` = 'p', `profession` = 'Web Designer', `employer` = 'Test Company', `college` = 'Test School', `year_started` = '2008-01-01', `bio` = 'This is a small section where I can fill out things about me.', `gender` = 'm', `dob` = '1985-03-13', `interests` = This is a small section where I can fill out things about my interests., `family` = This is a small section where I can fill out things about my family., `awards` = This is a small section where I can fill out things about my awards. WHERE id = '1'
As you can see the 'bio' is getting the quotes on it, but the last 3 long strings are not getting the quotes. Anyone have any ideas about this?
Thanks in advance,
-Chris