title: phpMyAdmin SQL Statement to expand or collapse group by
body: <p>I'm experiencing a couple issues. First, when using the below SQL statement.</p>
  
  <pre><code>SELECT `Name`,`Email`,`Phone` 
  FROM `jos_breezingforms_Contest_Registration` 
  GROUP BY `Contest` 
  </code></pre>
  
  <p>In this table I have three dummy entries. One entry with a 'Birthday' contest and two entries with a 'Office Party' contest.  And of those three entries there is one person with two contests (Birthday &amp; Office Party) and one person with one contest (Office Party). </p>
  
  <p>That said, this entry should have grouped two individuals under Office Party and one individual with Birthday.  But it did not. It displayed only the person who had both the Birthday and Office Party; and completely disregarded (or did not display) the one individual how had Office Party contest only.  </p>
  
  <p>What I need for it to do is not only group by contests but also make the results of those groups expandable/collapsible so that one has click on the toggle of the contest in question to expand and see results.  </p>
  
  <p>I can't find anything online that offers any advise on this. Does anyone in this network have any words of wisdom for me?</p>