I need an insert statement that will do roughly this:
INSERT INTO
tblContent(postTitle, postBody, postAuthor, postDate, postApproved, fromSite)
SELECT tblSubmissions.body
WHERE tblSubmissions.submissionId = 1
But I need to manually supply the rest of the fields. Is this possible? Or do I need to insert once, and then update? If I need to insert, then update, I know that I can probably use PDO::lastInsertId for this, but could someone provide a clear example, please?