Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Sorry the title isn't very descriptive, but it's a strange problem I'm trying to solve which may take a while to explain.
I'm trying to build a gallery, and on the front page I need to build a list of categories and albums. The idea is that each album will have it's name, description and a sample image (the most recent added)
These albums are then grouped by category. The problem is that I need to get data from 3 different tables, and ideally I'd like to do it all in the same query.
This is the query I used for getting album data and grouping it by cat:
[syntax="sql"]SELECT * FROM gallery_category INNER JOIN gallery_album ON(category_id=album_category) ORDER BY category_id;Code: Select all
SELECT * FROM (gallery_category INNER JOIN gallery_album ON(category_id=album_category)) INNER JOIN gallery_photo USING(album_id) ORDER BY category_id;Does anyone have any ideas on how to solve this?
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]