[SOLVED] photos with galleryID, galleries with categoryID, have categoryID, need photos

[ultrus]

I'm creating a basic photo gallery management tool. Categories contain galleries, and galleries contain photos. For an easy query, I could include category AND gallery ids in the photo table, but that's redundant right? So instead, my photo row just contains the gallery id it belongs to, and the gallery row includes what category id it belongs to. So here's the question: If I have a category id, what's the best way to get all the photos that belong to that catigory's galleries?

 

To get the galleries of a category I would query this:

SELECT id FROM gallery WHERE category_id = 24

 

To get the photos of a gallery I would query this:

SELECT id FROM photo WHERE gallery_id = 46

 

How do bridge the gap to get all the photos from a category id?

 

Thanks for the assist.

[ultrus]

Oh duh. I'm feeling silly tonight. Here's the basic solution:

 

SELECT photo.id FROM photo, gallery WHERE gallery.category_id = 49 AND photo.gallery_id = gallery.id