Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Block last added Albums  (Read 3944 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.021 seconds with 18 queries.