title: Storing Table from join as PHP varible
body: <p>So I have got as far as this many to many join </p>
  
  <pre><code>$manyJoin = "SELECT projects.name AS project_name ,tags.name AS tag_name 
               FROM `projects` AS projects                                 
               LEFT JOIN `project_tags` AS pt 
               ON projects.id = pt.project_id 
               LEFT JOIN `tags` AS tags ON pt.tag_id = tags.id
               WHERE tags.name IS NOT NULL;";
  </code></pre>
  
  <p><strong>Which gives me this table</strong></p>
  
  <pre><code>project_name    tag_name
  project_1       iphone
  project_1       android
  project_2       android
  project_2       windows
  </code></pre>
  
  <p>How do i then query this table to <code>echo</code> each project with a list that projects tags. Or can i rewrite my query to get what i need? Thanks.</p>
  
  <p><strong>Wanted output.</strong></p>
  
  <pre><code>project_1 iphone android
  project_2 android windows
  </code></pre>