[Solved]: Show the last albums added in yout gallery in text mode

[jaiak]

Sorry for the rescue this post, I have installed the cpmfetch 2.0 and coppermine 1.4.14 in powweb.com server.

I have merge phpBB 2.0.22 and coppermine 1.4.14 installation.

I have in my index the cpmfetch work ok with the last comments, the last thumbnails, etc. But I can't show the last titles of my albums added in my gallery. I want show the titles in text mode. Can you help me?

Regards from spain anda thanks in Advance!

[Joachim Müller]

Read the docs and sticky threads here on this board - yours is not even a valid support request.

[jaiak]

Hello again Gaugau

I have read all documentatino but I don't find how Can I show the last album in text mode.

Regards from spain

[jaiak]

Hello Again

I had developed this code for show the last albums in text mode (show the title)

Code Select Expand

<?php define('IN_COPPERMINE', true); require('include/init.inc.php'); $base = rtrim($CONFIG['ecards_more_pic_target'], '/'); $albumpath = "$base/" . $CONFIG['fullpath']; $result = mysql_query("SELECT tb.aid, ta.title FROM {$CONFIG['TABLE_ALBUMS']} tb LEFT OUTER JOIN {$CONFIG['TABLE_ALBUMS']} ta ON tb.aid = ta.aid ORDER BY ta.aid DESC LIMIT 0,8"); while (list($aid, $title) = mysql_fetch_row($result)) {
echo "<li><a href=$base/thumbnails-$aid.html target=_top><font face=arial color=black><b>$title</b></font></a></li>"; } ?>

[Joachim Müller]

Making your code more readable:

Code Select Expand

<?php 
define('IN_COPPERMINE', true); 
require('include/init.inc.php'); 
$base = rtrim($CONFIG['ecards_more_pic_target'], '/'); 
$albumpath = "$base/" . $CONFIG['fullpath']; 
$result = mysql_query("SELECT tb.aid, ta.title FROM {$CONFIG['TABLE_ALBUMS']} tb LEFT OUTER JOIN {$CONFIG['TABLE_ALBUMS']} ta ON tb.aid = ta.aid ORDER BY ta.aid DESC LIMIT 0,8"); while (list($aid, $title) = mysql_fetch_row($result)) {
  echo "<li><a href=$base/thumbnails-$aid.html target=_top><font face=arial color=black><b>$title</b></font></a></li>"; 
} 
?>

[Fabricio Ferrero]

Regards from spain

I just remember you that the Spanish sub-board had just re-opened. If you have trouble whit the language, don't doubt to make your question there.

Regards.

[jaiak]

Very thanks fabri