Okay here goes what i have been trying to do is its really hard to explain so i will try and draw below:
Table1----------------------------- Table2
cat_id ----------------------------- review_id
name
This is how its displayed:
cat_id----------------------------- name
1 ----------------------------- Testing
Okay so what im trying to do is count hows many reivew ids in table are the same and cat_id in table1 and then display the results like this:
cat_id ----------------------------- name ----------------------------- result
1 ----------------------------- Testing ----------------------------- 23
Sorry if this sounds confusing just think about how i feel lol
Laymans Terms: count how many reviews are in each categorys