Hi everybody,

I've got a little problem, which I can't solve. It is as follow:
In my database I made a table with different fields.
One of the fields is named 'bedrag' and contains a numeric value like 15.47 or 78.16 
and so on.
If I want a value of the table I use in most cases the following code:

<?
$squery = mysql_query("SELECT * FROM finance WHERE posneg = 'af'",$db);
while($row = mysql_fetch_array($squery)) {

$bedrag = $row["bedrag"];
echo "$bedrag<br>";
}
?>

In this case I receive a list like:
15.47
78.16
and so on...

So far no problems, but I want to count all these values. I tried with SUM but with 
the following code it doesn't work:

$squery = "SELECT SUM(bedrag) AS Total FROM finance WHERE posneg = 'af'";

any suggestions how to do? I want to store it in a variabele ($total) so I can echo 
it. (E.g.: $total = 93.63 in this case)

Thanx in advance,

Robert van der Mast

Reply via email to