Having issues with sumin data from an array

[eluser]The Revel[/eluser]
My table contains this data:

Code:

tid     email               amount     date
1       [email protected]     500.00     2012-04-12
2       [email protected]     -10.00     2012-04-12
3       [email protected]     -15.50     2012-04-14
4       [email protected]     -25.10     2012-04-16
5       [email protected]     100.00     2012-04-18

I am trying to sum the amounts based on email address (transaction details)

Here is what I have while trying to debug:

Code:

$q2 = $this->db->query('SELECT *, SUM(amount) FROM transactions WHERE email="'. $useremail .'" GROUP BY email');
          if ($q2->num_rows() > 0)
            {
            $row2 = $q2->row();
            $this->data['sum'] = $query->result();
            
            }
          echo $this->data['sum'];

When I echo $this->data['sum'] I get "Array" and not the ammount. I am new to CodeIgniter and shamelessly have no idea what I am doing wrong. I want to pass this variable to the view page as I have a list of all the transactions, and need a total (account balance).

Any help is much appreciated.
Thank you.