So I want to select the profile pages and their key columns with the most comments. This could be done by doing many queries for instance by first looking at the comment table and using order by so that columns with the same repeating profile_id get shown first and then you could use that ID individually to select content from the profile table but this is annoying.
$query = "select a.person_name_first from profiles a join comments b on a.id = b.profile_id";
For example using this query every time there is a match found of the profile ID in the comment ID it adds the person over and over again to an array but I only want them added ONCE but I still want the order of the profiles added to correspond with how many comments they have!! It's very confusing. thanks guys