SELECT *,max({$CONFIG['TABLE_PICTURES']}.ctime) as maxctime,{$CONFIG['TABLE_ALBUMS']}.title AS title,{$CONFIG['TABLE_ALBUMS']}.aid AS aid FROM {$CONFIG['TABLE_PICTURES']},{$CONFIG['TABLE_ALBUMS']} WHERE {$CONFIG['TABLE_PICTURES']}.aid = {$CONFIG['TABLE_ALBUMS']}.aid AND approved = 'YES' $ALBUM_SET GROUP BY {$CONFIG['TABLE_PICTURES']}.aid ORDER BY maxctime DESC $limit
The above is my sql used in "lastalb" (last updated album)
It correctly displayed the list of last updated album
However, the thumbnail used is the first picture as arranged alphabetically
What i wanted is, to show the thumbnail of the last uploaded picture of that last uploaded album
Anyone can suggest a sql to do that ?
i have a similar question. I want the albums to use the same thumbnail which I specified in the album preferences, from the drop down menu. Anyone, any ideas?
thanks!
don't try to hijack other's questions. Your question differs from what yoshikiwei was requesting.
Joachim
Sorry Joachim. I thought my problem shares a similar solution like his.