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.:
- Original Message -
From: Becoming Digital [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 06:43
Subject: Re: [PHP-DB] Count database-values
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
-
From: Becoming Digital [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 06:43
Subject: Re: [PHP-DB] Count database-values
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
Digital' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 11:54
Subject: RE: [PHP-DB] Count database-values
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: 10 June 2003 12:15
I screwed up my own code. Silly me. It should read:
Surely your
PROTECTED]
To: 'Becoming Digital' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 11:54
Subject: RE: [PHP-DB] Count database-values
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: 10 June 2003 12:15
I screwed up my own code. Silly me
]; [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 13:14
Subject: RE: [PHP-DB] Count database-values
Edward,
Have you considered trying mysql_result()?
It appears that your query is going to always return a single piece of data:
Total. So you essentially have an array with only a single element. If you