active record insert issue

I'm trying to insert some info into a table. Here's my code:
$data = array(
        'client_id'    => $input['client_id'],
        'title'        => $input['title'],
        'slug'         => $input['slug'],
        'desc'         => $input['desc'],
        'date_create'  => now()
$this->db->insert('proof_albums', $data);

and I'm receiving a MySQL error back:
Quote: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 'desc, date_create) VALUES ('7', 'test', 'test-test', 'testest', 1277316812)' at line 1

INSERT INTO proof_albums (client_id, title, slug, desc, date_create) VALUES ('7', 'test', 'test-test', 'testest', 1277316812)

I'm not quite sure why this is. Can anyone point me in the right direction?

So I've run a few tests, and I know that it has something to do with 'desc' because the code runs fine if I take that line out.

In the database table, 'desc' is set as type 'text', with a collation of 'utf8_unicode_ci'. The $input array is receiving the value from a textarea via $_POST. There's nothing particularly special about the form though.

Still researching...

I guess the code didn't like my word choice of 'desc'. Once I changed that to 'description', it ran fine. Is there a reason for this? I'd like to know why if there is an answer, just so I'm the wiser in the future.

Desc is reserved word.

Well that would do it, thanks! Smile

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

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