title: Display result in group of rows and sum each groups value
body: <p>I do not have much experience with PHP/MySQL. I have a table with 3 fields: <code>id</code>, <code>particular</code>, and <code>amount</code> as shown below.</p>
  
  <pre><code>id   particular   amount
  1    Fees         5000
  2    Fees         3000
  3    Bill         9000
  4    Fees         4000
  5    Bill         3000
  6    Expense      2000
  7    Fees         1000
  </code></pre>
  
  <p>I want to show the data in groups as well as the sum of each individual group, like so:</p>
  
  <pre><code>particular   amount
  Fees         5000
  Fees         3000
  Fees         4000
  Fees         1000
  **Total        13000**
  Bill         9000
  Bill         3000
  **Total        12000**
  Expense      2000
  **Total        2000**
  </code></pre>
  
  <p>i try this query <code>SELECT SUM(amount), particular FROM sale_expense GROUP BY particular</code> and it added all the values, but it is not showing in the group as I need to display the data</p>