title: Find Total Sum of a column as All at the end of mysql result
body: <p>I would like to create a table like result with mysql so that i can use the data to plot in fusion charts so that i have totals in the y-axis and client_types in the x-axis, thus something like this</p>
  
  <pre><code>n+1'                     ' 
     '  '                  '
  10 '  '   '          '   ' 
     '  '   '   '      '   '
  0  '  '   '   '  '   '   '
     '__'___'___'__'___'___'___
        A   B   C  D  E   All   
  </code></pre>
  
  <p>My Query as shown below returns</p>
  
  <pre><code>SELECT DISTINCT(COUNT('client_type')) AS Total, client_type FROM `clients` GROUP BY client_type
  </code></pre>
  
  <p>returns </p>
  
  <pre><code>Total Client_type
   18     A
   26     B
   16     C
  101     D
    2     E
  </code></pre>
  
  <p>SO what I want is to be able to add under client type 'All' and sum(Total) thus</p>
  
  <pre><code>Total Client_type
   18     A
   26     B
   16     C
  101     D
    2     E
  168     All
  </code></pre>
  
  <p>Suggestions</p>