[Resolvido] p/q esse codigo ta dando erro retornando boleono ?

[Green 0]

essa linha da erro e retorna boleano

 

erro linha 42 // while ($row = mysql_fetch_assoc($posts)){

 

-------------------------------------------------------------------------------

 

"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_comments`
		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);

                $row=array();
                while ($row = mysql_fetch_assoc($posts)){
	        $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_comments'] === null) ? 'never' : $row['last_comments' ]   

                      );
               }
              return $rows;
                     }

[Andrey Knupp Vital 136]

Faça o seguinte .. troque

$posts = mysql_query($sql);

Por:

$posts = mysql_query($sql) or die ( mysql_error ( ) ) ;

[Green 0]

Faça o seguinte .. troque

$posts = mysql_query($sql);

Por:

$posts = mysql_query($sql) or die ( mysql_error ( ) ) ;

 

 

oque quer dizer esse:

 

 

Notice: Undefined index: last_comments in C:\web\www\weblog\posts.inc.php on line 55

[William Bruno 1501]

'last_comment'    => ($row['last_comment'] === null) ? 'never' : $row['last_comment' ]

pois precisa casar com o ALIAS ali.

[Andrey Knupp Vital 136]

Índice indefinido, você não está recebendo esse índice em um array .. outra coisa .. mude isto

$row=array();

 

Para:

$rows=array();

[Green 0]

porquanto resolvido vamos para para frente