How to receive sum of a Postgresql colum

[Anon]

Hello,

How do I get the sum of a column in a postgresql database with PHP?

I have tried the following but it does nt work:

        $resa= "SELECT sum (cost) AS bajen FROM clicks";

$res = pg_aggregate( $conn, $resa ) or die (Fel);
$total=pg_result($res,0,0);
echo "$total - $total[1]";

[Anon]

Put a group by in the end of your query !
.....
Group by Your_Colomn

[Anon]

        $resa= "SELECT sum (cost) AS bajen FROM clicks GROUP BY advertiser";

$res = pg_aggregate( $conn, $resa ) or die (Fel);
$total=pg_result($res,0,0);
echo "$total - $total[1]";

does not work. it gives Fatal error: Call to undefined function: pg_aggregate() in /home/home1/smozle/public_html/test.php on line 7

[Anon]

It have to look like that:

$resa = "SELECT sum(cost) AS bajen FROM clicks";
$res = pg_Exec($conn,$resa);
if ($res) {
$row = pg_Fetch_Object($res,0);
$total=$row->bajen;
} else {
echo "Error";
}
pg_FreeResult($res);