Having issues with sumin data from an array |
[eluser]The Revel[/eluser]
My table contains this data: Code: tid email amount date 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'); 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.
[eluser]The Revel[/eluser]
Ok, I modified the query a bit: Code: $q2 = $this->db->query('SELECT SUM(amount) FROM transactions WHERE email="'. $useremail .'" GROUP BY email'); Now if I run the query in my MySQL manager I get the return of Sum(amount) $$$$.$$ <- the actual sum But it still shows up as an array despire the fact I am getting back 1 item.
[eluser]Stefan Hueg[/eluser]
Try this Code: $q2 = $this->db->select('SUM(amount) as sum_amount', FALSE) I've also converted your query to ActiveRecord (you should get used to it http://ellislab.com/codeigniter/user-gui...ecord.html
[eluser]pbflash[/eluser]
result() will return an object regardless of how many entries it contains. You should use row() for a single result. Try: Code: $q2 = $this->db->query('SELECT SUM(amount) as total FROM transactions WHERE email="'. $useremail .'" GROUP BY email');
|
Welcome Guest, Not a member yet? Register Sign In |