Looping through two tables to produce a list?
Hello everyone, I am looking to use two tables within a query and output the results in php.
I have one table which holds details about a group and is called 'groups' with these columns
I have another table called 'people' who belong to these groups with these columns
What I'm looking to do is produce a list in php where I can loop through all the 'groups' and output each heading, then directly underneath that heading output all the their_name that are part of that particular group from the 'people' table.
Can anyone help here please. At the moment with my scenario I can't even think of the right terms to use a search engine for to find some similar scenarios which would help me, so even anything like that would be helpful. Thank you