Results 1 to 23 of 23
Thread: Need Help with a Join
Nov 4, 2008, 14:14 #1
- Join Date
- May 2005
- 0 Post(s)
- 0 Thread(s)
Need Help with a Join
Hi, I was wondering if someone could help me with a join, I have two tables, one for galleries, the other for images.
I don't know if its possible but I'd like to get all the gallery information but also how many images are in a gallery and also the size of the gallery (which is saved in bytes).
im_galleries [ g_id (PRIMARY KEY) g_title g_description g_slug g_thumbnail g_created_on]Code:
im_images [ i_id (PRIMARY KEY) gallery_id (FOREIGN KEY) i_type i_size i_filename i_title i_caption i_width i_height i_created_on]