[thelist] Gallery3 - Using SQL queries
Anthony Baratta
anthony at baratta.com
Sat Mar 20 13:53:48 CDT 2010
On 3/20/2010 8:57 AM, Todd Richards wrote:
> - Id (record id)
> - Name (such as the name of the album (ie "my-album" or "image.jpg"))
> - Parent_id (the id of the album that the images belong to)
> - Relative_path_cache (ie "my-album/image.jpg")
> - Relative_url_cache (ie "my-album/image)
> - Slug (ie "my-album" or "image")
> - Type (photo or album - it also allows for videos)
> - View count (number of hits)
Something like this?
select
Image.Relative_path_cache
from <table> as Image
join <table> as Album on
Image.Parent_Id = Album.Id
where
Image.Name = @Name
AND
Album.Name = @Album
Is that what you are looking for?
--
Anthony Baratta
Freedom is messy.
-- Mark Steyn
More information about the thelist
mailing list