I have two tables that are joined together but I cannot seem to retrieve ALL the data from a selected linked category–maybe this is a PHP thing; let me know and I’ll move to the other forum.
1 Just For Fun
2 Special Results
3 All for It
gallery_id cat_id filename caption
1 1 xxxxxx.jpg ;alskjf;laskdjf
2 2 xxxxxx.jog ;alskdjf;lkajsdf
3 3 xxxx.jpg 0987a;lkjhd
4 1 ss.jpg ;kj;lakjsd
This is my query:
FROM T1 JOIN T2 ON T2.cat_id = T1.cat_id
WHERE T1.cat_id = T2.cat_id
Say I click on the link for Category 1; instead of getting all of the photos for Category 1, I get just one and one of each other category. I tried GROUPING, but I got the same results.
Where am I missing it?