album/cat id and album/cat name

[cocostaff]

Is there a simple way to get a list of Album name & Album id ?? same question for category. How the id is determined by coppermine ? Does it correspond to the rank of the album in the coppermine albumlist ?

Thanks !

[Joachim Müller]

The album and category IDs are counted upwards, so the time of creation is the criteria that is being taken into account. Not sure if cpmFetch contains a method to populate an array/list of existing albums or categories.

[cocostaff]

so there is no direct way to know the specific ID of an album/cat... do you think it is possible to perform a database query to list the album ID in front of the album names ?

[Nibbler]

Just go into phpmyadmin and browse your album and category tables.

[vuud]

so there is no direct way to know the specific ID of an album/cat... do you think it is possible to perform a database query to list the album ID in front of the album names ?

I think you could use CpmFetch, have it return a result set and output based on that.  I figure since it is posted here, I would suggest a cpmfetch orienteed solution.

[cocostaff]

Nibbler's solution is simple and work well, you can export the entire coppermine_albums table in csv file ! Thanks

Vuud, i think that a cpmfetch oriented solution will be great, and calling album_title in cpmfetch function  instead of id can be more efficient.

[vuud]

Nibbler's solution is simple and work well, you can export the entire coppermine_albums table in csv file ! Thanks

Vuud, i think that a cpmfetch oriented solution will be great, and calling album_title in cpmfetch function  instead of id can be more efficient.

I probably won't implement that ... I can see the posts, hundreds of them, all due to typos

That being said, calling by title may be "easier" for the user, but I doubt a text search in SQL would be more efficent.

People tend to just code in CpmFetch stuff once... for that its easy enough to just look at your gallery in a web page and note the album id or cat id...

Thats my opinion anyway