#1064 - Problem with SQL Syntax :(

[xFuSaiH]

Hello guys. I have been following a tutorial on PHP Blog...

Now when I put this code

[syntax=sql]SELECT
'posts'.'post_id' AS 'id',
'posts'.'post_title' AS 'title',
LEFT('posts'.'post_body', 512) AS 'preview',
'posts'.'post_user' AS 'user',
DATE_FORMAT('posts'.'post_date', '%d/%m/%Y %H:%i:%s') AS 'date',
'comments'.'total_comments',
DATE_FORMAT('comments'.'last_comment', '%d/%m/%Y %H:%i:%s') AS 'last_comment'
FROM 'posts'
LEFT JOIN (
SELECT
'post_id',
COUNT('comment_id') AS 'total_comments',
MAX('comment_date') AS 'last_comment'
FROM 'comments'
GROUP BY 'post_id'
) AS 'comments'
ON 'posts'.'post_id' = 'comments'.'post_id'
ORDER BY 'posts'.'post_date' DESC[/syntax]

to SQL in my Database to check for syntax I get this back

#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 '.'post_id' AS 'id', 'posts'.'post_title' AS 'title', LEFT('posts'.'post_' at line 2

I really want this blog to happen, so can anyone here please help me ? It would be much appreciated.

Thanks a lot in advance

Patryk

[jacek]

You have quotes around your column names, they should be backticks --> `

[xFuSaiH]

Thank You very much sir

I am ashamed of myself now...

Hope I will make this blog, thanks a lot again

[jacek]

It's a very common mistake so don't feel too bad