last 10 comments

[lasa]

Hi,

How can I display the last 10 comments in text-only on a non-coppermine page? Just on the homepage, so the visitors can see the latest actions, and click on it.

Laurens.

[DJMaze]

run a SQL query on the cpg_comments table and in that query add "ORDER BY msg_date DESC" then retrieve the first X rows where X is the total you want to show.

example:

Code Select Expand

$sql = "SELECT msg_author, msg_body, msg_date FROM cpg_comments ORDER BY msg_date DESC LIMIT 10";
$result = $db->sql_query($sql);
while ($value = $db->sql_fetchrow($result)) {
    echo $value['msg_body'] . " by " . $value['msg_author] . " on " . $value['msg_date'] . "<br>";
}

[lasa]

Thnx very much, after a little bit modifying, it works now.
Do you know how I can let the comment link to the concerned photo?

Laurens.

[Joachim Müller]

[list=1]

• this is a support request, not a feature request; I therefor move this thread to the support board
• only one issue per thread![/list:o]lasa: you were close to a ban in the past; behave yourself and stick to the rules (post on the right boards etc.)
  
  GauGau

[lasa]

1. Sorry for that.
2. I want to expand this feature. So I have to create for every issue of this feature an new topic?
3. Thnx for moving the topic...