forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 PHPnuke/Postnuke Support => Topic started by: greeny on November 20, 2003, 04:03:52 pm

Title: Block last added Albums
Post by: greeny on November 20, 2003, 04:03:52 pm
How can I make a block that show the last 10 added Albums

Greetz
Sascha
Title: Block last added Albums
Post by: DJMaze on November 20, 2003, 06:46:43 pm
$db->sql_query("SELECT * FROM cpg_albums SORT BY aid DESC");
Title: Block last added Albums
Post by: greeny on November 20, 2003, 07:48:27 pm
How Can I integrate this ??

i tried it but it didnīt work
Title: Block last added Albums
Post by: DJMaze on November 20, 2003, 08:50:23 pm
check the other blocks gtroll created and are in your blocks folder.

If you don't understand php then learn php or else wait untill someone does it for you.

My previous post contains the database query which is needed as answer to your question.