Why did this properly escalate the SQL query?

Question

Here's the request:

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

All data types are correct, it always fails in the question, so I suppose I should avoid the values.

I am sure that one of you will immediately see my idiotic mistake. Help a little?

Answer 1

SQL confuses 'to' from a string to a function.

Try:

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