PHP/MySQL News with Comments - Displaying one item with comments

(Page 5 of 7 )

So, we have displayed all the news and we have displayed the comments. We need to tie it together. When a user clicks on the comments link from the main news page, we need a way to display the single news item with the comments. To do that, we will query the news table for the id of the news item we are looking for and display that news. Then, we will simply call the displayComments function to show the comments.

<?php function displayOneItem($id) {     global $db;          /* query for item */     $query = "SELECT * FROM news WHERE id=$id";     $result = mysql_query ($query);          /* if we get no results back, error out */     if (mysql_num_rows ($result) == 0) {         echo "Bad news id\n";         return;     }     $row = mysql_fetch_assoc($result);     echo "&lt;TABLE border=\"1\" width=\"300\"&gt;\n";     /* easier to read variables and       * striping out tags */     $title = htmlentities ($row['title']);     $news = nl2br (strip_tags ($row['newstext'], '&lt;a&gt;&lt;b&gt;&lt;i&gt;&lt;u&gt;'));          /* display the items */     echo "&lt;TR&gt;&lt;TD&gt;&lt;b&gt;$title&lt;/b&gt;&lt;/TD&gt;&lt;/TR&gt;\n";     echo "&lt;TR&gt;&lt;TD&gt;$news&lt;/TD&gt;&lt;/TR&gt;\n";          echo "&lt;/TABLE&gt;\n";     echo "&lt;BR&gt;\n";          /* now show the comments */     displayComments($id); } ?>

Next: Adding 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...    · I have already implemented a comment feature on my website.. I was looking for a...   >>> Post your comment now!