error db :S [UPDATE]

[eluser]MMCCQQ[/eluser]
hi


i dont know what happed!...

my table db

id
to
from
subject
body

Code:

$this->db->insert('message', $_POST);

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 'to, from, subject, bod) VALUES ('dfd', '1', 'fdf', 'gdfgdfg')' at line 1

INSERT INTO message (to, from, subject, bod) VALUES ('dfd', '1', 'fdf', 'gdfgdfg')

[eluser]gtech[/eluser]
why don't you know what happened? <- [edit] sorry must of not read bottom bit of your question, unless it was updated.

[eluser]John_Betong[/eluser]
Hi ,

You are missing the 'y' to your body:

Code:

// Your code
// INSERT INTO message (to, from, subject, bod) VALUES (’dfd’, ‘1’, ‘fdf’, ‘gdfgdfg’)
    INSERT INTO message (to, from, subject, body) VALUES (’dfd’, ‘1’, ‘fdf’, ‘gdfgdfg’)

Cheers,

John_Betong
&nbsp;

[eluser]MMCCQQ[/eluser]
Solved!

to and from cant be user