Why does this properly escaped SQL query fail?

Question

Here's the query:

INSERT INTO jobemails (jobid, to, subject, message, headers, datesent) VALUES ('340', '[email protected]', 'We\'ve received your request for a photo shoot called \'another\'.', 'message', 'headers', '2010-04-22 15:55:06')

The datatypes are all correct, it always fails at the subject, so it must be how I'm escaping the values, I assume.

I'm sure one of you will see my idiot mistake right away. A little help?

Answer 1

SQL is confusing 'to' from row to a function.

Try:

INSERT INTO `jobemails` (`jobid`, `to`, `subject`, `message`, `headers`, `datesent`) VALUES ('340', '[email protected]', 'We\'ve received your request for a photo shoot called \'another\'.', 'message', 'headers', '2010-04-22 15:55:06')