[therealdaveharvey]

Is there a way to pull the comments from the DB in to a separate section of the site. as the user post a comment on the site in any section the recent comment section gets up dated and where or what they comments on ? i am never to php is there anyone that can help ,me?

therealdaveharevy

[Steven]

Hi,

You could experiment with this. You will need to replace "localhost", "mysql_user", "mysql_password" and "database" with the correct values.

PHP Code:

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");

mysql_select_db("database", $link);



$result = mysql_query("SELECT * FROM comments WHERE is_approved = '1' ORDER BY dated DESC LIMIT 5", $link);



while ($comments = mysql_fetch_assoc($result)) {

    echo $comments["comment"];

    echo "<p />";

}

?>

[therealdaveharvey]

thanks alot sir, I will give it a try and let you know how it turns out
-
Dave Harvey

[therealdaveharvey]

Is there a way to know here the user commented to and link to the comment like this example www.topmmanews.com? this is what i am trying to achieve.

[Steven]

An add-on is now available for this:
http://www.commentics.org/add-ons.php#recent_comments

[stevylake]

An add-on is now available for this:
http://www.commentics.org/add-ons.php#recent_comments

Hi I have downloaded the Add On but I just have one security question.

In order to implement the code The Database information has to bee entered, including the password etc. Doesn't that mean that anyone looking at my source code will know all the details to access my database etc?

Thanks

[Steven]

Hi,

The database information is entered using PHP, which is a server-side programming language, so it won't be displayed in the client-side source code.