title: Output MySQL list of records, grouped by category?
body: <p>I have data like this:</p>
  
  <pre>
  <b>Category</b>     <b>Product</b>
  Mustards     Hot Mustard
  Mustards     Horseradish Mustard
  Mustards     Honey Mustard
  Sauces       Tomato Sauce
  Sauces       Barbeque Sauce
  </pre>
  
  <p>And I'd like to get this output:</p>
  
  <pre>
  <b>Mustards</b>
  Hot Mustard
  Horseradish Mustard
  Honey Mustard
  
  <b>Sauces</b>
  Tomato Sauce
  Barbeque Sauce
  </pre>
  
  <p>I thought I could do it with GROUP BY and/or DISTINCT, like this:</p>
  
  <pre>
      SELECT DISTINCT category, prodName
      FROM recipes
      GROUP BY category
      ORDER BY category, prodName ASC
  </pre>
  
  <p>but I'm not having much luck. Can anyone help?</p>
  
  <p>Thanks - Joe</p>