Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Block last added Albums  (Read 3946 times)

0 Members and 1 Guest are viewing this topic.

greeny

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Block last added Albums
« on: November 20, 2003, 04:03:52 pm »

How can I make a block that show the last 10 added Albums

Greetz
Sascha
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Block last added Albums
« Reply #1 on: November 20, 2003, 06:46:43 pm »

$db->sql_query("SELECT * FROM cpg_albums SORT BY aid DESC");
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0

greeny

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Block last added Albums
« Reply #2 on: November 20, 2003, 07:48:27 pm »

How Can I integrate this ??

i tried it but it didnīt work
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Block last added Albums
« Reply #3 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.
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 18 queries.