Last 5 comments on my site

[lasa]

I want to display the last 5 comments on my site, not in coppermine.
How can you do that?

[Tarique Sani]

A query like

Code Select Expand

SELECT * FROM `cpg_comments` ORDER BY `msg_date` DESC  LIMIT 0 , 5
Will return the last 5 comments, write a small PHP script to PRINT where ever

[lasa]

Thnx!
But how can I add also a link to that photo?

[Tarique Sani]

But how can I add also a link to that photo?

The pid column returned is the picture ID to link to the picture use URL like
http://www.tariquesani.net/displayimage.php?pos=-56

The last number in the above URL is the pid and don't forget the minus sign(-) before the pid number

Of Course link it to your domain not mine

[lasa]

Can you make that small php script for me, please?

[Tarique Sani]

Can you make that small php script for me, please?

:lol:  :lol:  :lol:  :lol: NO!

[lasa]

Grrr... I can't get it how to echo the query... Grrr

[Joachim Müller]

take a look at http://prdownloads.sourceforge.net/coppermine/ssi.zip?download

GauGau

[Tarique Sani]

take a look at http://prdownloads.sourceforge.net/coppermine/ssi.zip?download

Oh Great! You rescued that one!!

[lasa]

take a look at http://prdownloads.sourceforge.net/coppermine/ssi.zip?download

Oh Great! You rescued that one!!

Even as the FAQ...

[Joachim Müller]

rescuing it was easy - always has been on my hard-drive (I coded it :wink: ). But as I mentioned on the old board: you're not encouraged to use it, as it doesn't give a damn about permissions - it has to be redone (someday).

GauGau