PHP/MySQL News with Comments - Displaying the comments

(Page 4 of 7 )

The next thing we want to do is display comments. Like I mentioned earlier, we need to query the comments table for rows that where news_id matches the piece of news being viewed.

<?php function displayComments($id) {     /* bring db connection variable into scope */     global $db;          /* query for comments */     $query = "SELECT * FROM news_comments WHERE news_id=$id";     $result = mysql_query ($query);     echo "Comments:&lt;BR&gt;&lt;HR width=\"300\"&gt;\n";          /* display the all the comments */     while ($row = mysql_fetch_assoc ($result)) {         echo "&lt;TABLE border=\"1\" width=\"300\"&gt;\n";                  $name = htmlentities ($row['name']);         echo "&lt;TR&gt;&lt;TD&gt;&lt;b&gt;by: $name&lt;/b&gt;&lt;/TD&gt;&lt;/TR&gt;\n";              $comment = strip_tags ($row['comment'], '&lt;a&gt;&lt;b&gt;&lt;i&gt;&lt;u&gt;');         $comment = nl2br ($comment);         echo "&lt;TR&gt;&lt;TD&gt;$comment&lt;/TD&gt;&lt;/TR&gt;\n";              echo "&lt;/TABLE&gt;\n";         echo "&lt;BR&gt;\n";     }          /* add a form where users can enter new comments */     echo "&lt;HR width=\"300\"&gt;";     echo "&lt;FORM action=\"{$_SERVER['PHP_SELF']}" .          "?action=addcomment&amp;id=$id\" method=POST&gt;\n";     echo "Name: &lt;input type=\"text\" " .          "width=\"30\" name=\"name\"&gt;&lt;BR&gt;\n";     echo "&lt;TEXTAREA cols=\"40\" rows=\"5\" " .          "name=\"comment\"&gt;&lt;/TEXTAREA&gt;&lt;BR&gt;\n";     echo "&lt;input type=\"submit\" name=\"submit\" " .          "value=\"Add Comment\"\n";     echo "&lt;/FORM&gt;\n";       } ?>

As you can see, this is very similar to the displayNews function. In both, all we are doing is querying the database and looping to display all the data returned. On way you could enhance this would be to add a postdate field to the comments table and then order the comments query by date.

Next: Displaying one item with comments >>
 

More Database Articles Articles
More By Matt Wade

Comments On: PHP/MySQL News with Comments

· dfsf    · Thanks for a great tutorial.    · hiI've search the web for ages to find a newssystem that does excatly what this...    · I seem to be getting the problem where it's not showing the news table at all and...    · sounds like it doesn't interact with your "news"-database as it...    · file loaded: http://luna-illusions.co.uk/weetom/newsscript.phpThere's no design...    · Hi.I just love this Tutorial and it works perfectly except for 1 thing. When you...    · Warning: mysql_connect() [function.mysql-connect]: Access denied for user...    · I've discovered a problem with this tutorial. The Comment can only be 500 Characters...    · Tutorial is nice, but previous one was better, this one is just final script cut...    · Hello Mr/Mrs Tutorial Creator (xD)I'm new toP and MySQL and I suck basically...   >>> Post your comment now!