I have 2 tables that store entries by members and it has the following fields:
table1
t1_id
project_ID
member_ID
question
table2
t2_id
project_ref
reply_id
answer
So I loop through table1 and output all questions WHERE member_ID = 555
What I need is to add to the same query, where I join the two tables and while I output the questions I also count how many answers stored in table2 for each question. By the way
table1.project_ID == table2.project_ref
My brain is making empty loops at the moment... Need help writing this query.