Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

Please sign in or apply for membership to remove the ads

General Support: help with Query to get last 5 added albums?

Bottom of Page

1 to 1 of 1

  1.  
    • CommentAuthorjalex9
    • CommentTimeNov 17th 2008
     
    I have a Wordpress plug in widget that will display the last 5 photo's submitted or 5 random picures in my sidebar using queries like these:

    SELECT * from plogger_pictures order by date_submitted DESC LIMIT 5
    SELECT * from plogger_pictures order by RAND() LIMIT 5

    I've copied and pasted from various sources to get this to work. I would like to have another sidebar item that would list url's for the last 5 albums created and wondering if anyone could help. I don't know SQL and don't really know how to create my query.

    It looks like albums are auto incremented so a query to return the count - 5 through count would get me the last 5 added albums. Then I can use the path's to generate links.

    Anyone able to help me with the query?

    Thanks in advance...

1 to 1 of 1

  1.