calculate the total of an array

[cristiart]

I am pulling data from a MySQL database. I want to print out all individual rows, then total them. My use of arrays and sum of those arrays has me baffled. I want to print out one total value that sums all data from field "total". This is in joomla

function totalsales($total)
{
$db =& JFactory::getDBO();
$query = "SELECT total,contact_id FROM #__invoices WHERE contact_id='$total' ";
$db->setQuery($query);
$sum = $db->loadObjectlist();

     print_r (array_values($sum));

}

$total3 = (contactsearch($this->row->id));

I think i have to go through a loop, but i'm stuck 😕

[NogDog]

Depending on what you need to do, you may be able to get the database to do it for you, e.g.:

SELECT SUM(total) AS grand_total FROM . . .

[cristiart]

here's what i got so far:

$query = "SELECT SUM(total),contact_id FROM #__invoices WHERE contact_id='$total' ";
$db->setQuery($query);
$sum = $db->loadObjectlist();

	print_r ($sum[0]);
     echo $sum[0]->total;

this is calculating the total but how can i echo it out. it not showing to amount only the print_r shows stdClass Object ( [SUM(total)] => 152 [contact_id] => 62

thank you

[Derokorian]

As the print_r shows, the property name is SUM(total) so you could attempt to use it that way (could cause problems) or you could use an alias in your query to get a sensible column name to access.

[cristiart]

what am I missing???????
this is my array
Array ( [0] => stdClass Object ( [SUM(total)] => 152 [contact_id] => 62 ) )

and i'm trying to print the total like this
print $sum[0]->SUM(total);

but it's not working and it's driving me crazy.......

[cristiart]

i found the solution, it's in Joomla settings

I had to change

$sum = $db->loadObjectlist();

in to:

$sum = $db->loadResult();

thanks for all the help guys