Having issues with sumin data from an array

[eluser]Stefan Hueg[/eluser]
Try this

Code:

$q2 = $this->db->select('SUM(amount) as sum_amount', FALSE)
   ->from('transactions')
   ->where('email', $useremail)
   ->group_by('email')
   ->get();

  if ($q2->num_rows() > 0)
  {
   $this->data['sum'] = $q2->row()->sum_amount;  
  }
  echo $this->data['sum'];

I've also converted your query to ActiveRecord (you should get used to it
http://ellislab.com/codeigniter/user-gui...ecord.html