I've actually mentioned this in another post where the extremely helpful acrylian gave me some help as to solving another issue but this remains unsolved and so this is why I'm creating another thread with a useful title.
The function getSubAlbums has got me so far, telling me how many sub albums are in the immediate folder, or album.
However in the real world things are more than 1 level deep and should I have a layout like this:
Parent
>>>>>Child 1
>>>>>Child 2
>>>>>>>>>>>Child Child 1
>>>>>>>>>>>Child Child 2
At present the parent sub-album would show 2, however it should show 4, as the nested sub albums still exist.
I know that there should be some way of parsing through the database with SQL but I can't for the life of me work out the correct query to display the true number of sub albums in an albums description.
I've got far with the functions today and have used them with some fresh PHP knowledge to allow for conditional resizing etc, but this is something else, and a problem I don't think I can fix without a little help from somebody with some SQL knowledge.
Perhaps I've overlooked something, but I would expect GetSubAlbums to function more than 1 level deep, otherwise it really only supports a very limited and flat album structure.
Thanks.