sistema de comentario

[Green 0]

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\weblog\posts.inc.php on line 44

 

 

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();

// 44  // aqui linha 44 essa abaixo //--------------------------------------------------------------

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;
}

[Henrique Barcelos 290]

Observe:

($row = mysql_fetch_assoc($posts)) !== false

Isso é uma COMPARAÇÃO, o resultado é BOOLEANO, ou seja, true ou false.

 

O jeito correto de fazer é:

while ($row = mysql_fetch_assoc($posts)){
   //...
}