PHP Blog Tutorial [Issue]

[TomTheCoder]

I've been following the Blog tutorial, and it gives me the following error when I attempt to use what I've coded so far(When hosting blog_list.php):

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /core/inc/posts.inc.php on line 42

This is my code in line 42:
while (($row = mysql_fetch_assoc($posts)) !== false)

And this is the entire function:

function get_posts() {
	$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";
	
	$posts = mysql_query($sql);
	
	$rows = array();
	while (($row = mysql_fetch_assoc($posts)) !== false) {
		$rows[] = array(
			'id' 			=> $row['id'],
			'title'			=> $row['title'],
			'preview'		=> $row['preview'],
			'user'			=> $row['user'],
			'date'			=> $row['date'],
			'total_comments'	=> ($row['total_comments'] === null) ? 0 : $row['total_comments'],
			'last_comment'		=> ($row['last_comment'] === null) ? 'never' : $row['last_comment']
		);
	}
	
	return $rows;
	
}

Thanks,
Tom.

[ExtremeGaming]

Change all the apostrophes around your column names to backticks `

[TomTheCoder]

All fixed, thanks!