title: How do I output the results of a mysql query as a list?
body: <p>I have a MYSQL database that lists stores and their products with categories and subcategories.
  I can query the database and output all the results I want using PHP but I only know how to make it come out as follows:</p>
  <p><b>Store-1</b><br>
  product-1<br>
  <b>Store-1</b><br>
  product-2<br>
  <b>Store-1</b><br>
  product-3<br>
  <b>Store-2</b><br>
  product-1<br>
  <b>Store-2</b><br>
  product-2<br>
  <b>Store-2</b><br>
  product-3<br>
  etc....</p>
  <p>What I want to do is output the data with the store name only mentioned once followed by the
  products for each store.
  Like this:</p>
  <p><b>Store-1</b><br>
  Product-1<br>
  Product-2<br>
  Product-3<br>
  <br>
  <b>Store-2</b><br>
  Product-1<br>
  Product-2<br>
  Product-3<br></p>
  <p>Would I need to do a MYSQL SELECT sub-query to accomplish this? I'm not really sure how it's done.</p>
  <p>Thanks for the help</p>