[SOLVED] sum row in database

[davelr45]

I am selecting values from a postgre db and turning them into an associative array. I need to sum the total selected from a field, similar to excel's sum function.

 

Example- select * from tablename where date BETWEEN $date_ a AND $date_b

Output-

date: 5/26/07 code:XXXX  count:12

date: 5/27/07 code:XXXX  count:19

date: 5/28/07 code:XXXX  count:17

date: 5/29/07 code:XXXX  count:11

 

                            Count Total: ???????

 

 

[Wildbug]

Why not just add them up in PHP while you're printing them and then echo the sum?

 

$total = 0;

while (/* reading from database */) {
echo "date: $date code: $code count: $count<br>\n";
$total += $count;
}
echo "Total: $total";

 

Otherwise, a seperate query using a SUM() function should work (I'm not familiar with PostGRE's functions, so I'm not sure exactly what it would be).

[davelr45]

Thanks that did it!