|
Posted by Gordan on 09/16/05 19:34
when coding an image gallery script there's usually 2 tables - pics and
galleries
every pic has some name, description, yada yada and gallerieID. so when you
wan't all the pics from a certain gallerie all you have to do is "SELECT * FROM
pics WHERE gallerieID = 33"
but often I have a need for other types of galleries like "most popular pics" or
"most recent". still this is very simple because when displaying this pics all I
have to do is "SELECT * FROM pics ORDER BY popularity DESC LIMIT 0, 20"
here comes my question :-)
how to put both types of galleries (lets call them static and dynamic) into one
gallerie table so that I can transparently list images regardless of the
specific query involved?
thanks
gordan
Navigation:
[Reply to this message]
|