continuado sistema comentario

[Green 0]

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in line 84 post.php

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in line 13 comments.php

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

comments.php

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

<?php

function get_comments($pid){

$pid = (int)$pid;

 

$sql = "SELECT

'comment_body' AS 'body',

'comment_user' AS 'user',

DATE_FORMAT('comment_date' , '%d/%m/%y %H:%i:%s') AS 'date'

FROM 'comments'

WHERE 'post_id' = {$pid}";

 

$return=array();

------- LINHA 13 ----- while(($row = mysql_fetch_assoc($comments)) !== false){

$return[] = $row;

}

return $return;

}

 

 

function add_comments($pid, $user, $body) {

if (valid_pid($pid) === false){

return false;

 

}

$pid = (int)$pid;

$user = mysql_real_escape_string(htmlentites($user));

$body = mysql_real_escape_string(nl2br(htmlentites($body)));

 

mysql_query ("INSERT INTO 'comments' ('post_id' , 'comment_user', 'comment_body','comment_date')

VALUES

( '{$pid}', '{$user}', '{$body}', NOW() )");

 

return true;

}

?>

 

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

 

posts.php

 

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

 

 

 

function get_post($pid){

$pid = (int)$pid;

$sql = "SELECT

'post_title' AS 'title' ,

'post_body' AS 'body' ,

'post_user' AS 'user' ,

'post_date' AS 'date'

FROM 'posts'

WHERE 'post_id' = {$pid}";

 

$post = mysql_query($sql);

-------LINHA 84 ------------- $post = mysql_fetch_assoc($post);

$post ['comments'] = get_comments($pid);

 

return $post;

 

}

 

function add_post( $name, $title, $body){

$name = mysql_real_escape_string(htmlentites($name));

$title = mysql_real_escape_string(htmlentites($title));

$body = mysql_real_escape_string(nl2br(htmlentites($body)));

 

mysql_query ("INSERT INTO 'posts' ('post_user' , 'post_title', 'post_body','post_date')

VALUES

( '{$name}', '{$title}', '{$body}', NOW() )");

}

[Guilherme_90 33]

Primeiramente. Onde existe esta variavel "$comments" ? O próprio erro já diz, ou seja, esta função pede um parametro, e você tá passando uma variavel que não existe no parametro.

 

Faz assim:

 

$sql = "SELECT * FROM tabela";
$res = mysql_query($sql);

while($dados = mysql_fetch_assoc($res)){
   echo "
      Nome: {$dados['nome']}
   ";
}

 

Código não testado!