MySQL INSERT INTO Syntax Error 1064
===

Sorry all, once again my MySQL statement has a syntax error! I'm quite sure it's the JSON, but I am using `mysqli_real_escape_string` to escape it, though this might not be enough?

Here is my statement:

<code>INSERT INTO emails (attachments, cc, cc_full, date, `from`, headers, html_body, mailbox_hash, message_id, reply_to, send_date, subject, tag, text_body, `to`, to_full) VALUES ([{\"Content\":\"VGhpcyBpcyBhdHRhY2htZW50IGNvbnRlbnRzLCBiYXNlLTY0IGVuY29kZWQu\",\"ContentLength\":60,\"ContentType\":\"text\\/plain\",\"Name\":\"test.txt\"}], \"First Cc\" <firstcc@postmarkapp.com>, secondCc@postmarkapp.com, [{\"Email\":\"firstcc@postmarkapp.com\",\"Name\":\"First Cc\"},{\"Email\":\"secondCc@postmarkapp.com\"}], Mon, 5 Mar 2012 14:33:50 +0100, support@postmarkapp.com, [{\"Name\":\"X-Header-Test\",\"Value\":\"\"}], <html><body><p>This is a test html body.</p></body></html>, SampleHash, 73e6d360-66eb-11e1-8e72-a8904824019b, replyto@postmarkapp.com, 2014-08-14 09:06:00, 14-08-2014 09:06, TestTag, This is a test text body., \"Firstname Lastname\" <mailbox+hash@inbound.postmarkapp.com>, [{\"Email\":\"mailbox+hash@inbound.postmarkapp.com\",\"Name\":\"Firstname Lastname\"}])</code>

I get this error:

`"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 '[{\"Content\":\"VGhpcyBpcyBhdHRhY2htZW50IGNvbnRlbnRzLCBiYXNlLTY0IGVuY29kZWQu\",\' at line 1 (1064)"`

I really hope someone can help! I would also really appreciate an explanation as to where I'm going wrong so I know for next time! Thank you all, much appreciated :)

