Re: Adding totals
| From: | César L . Aracena | Date: | Tue, 21 May 2002 15:30:17 +0000 |
| Subject: | Re: Adding totals | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19326@lists.php.net to get a copy of this message | ||
It works...
Thanks a lot.
----- Original Message -----
From: Adam Royle
To: caracena@infovia.com.ar ; php-db@lists.php.net
Sent: Tuesday, May 21, 2002 2:11 AM
Subject: Re: Adding totals
This should be it (if I am understanding you correctly).
Adam
$strSQL = "SELECT SUM(columnName) as sum FROM tblName";
$result = mysql_query($strSQL);
while ($row = mysql_fetch_array($result)){
$total = $row["sum"];
}
--------------------------------
Hi all,
Is there a way for me in PHP4 to add all the contens (floating numbers) =
of a cartain column whithin a row and show up the result? I have several =
time inputs and need to show the total.
Thanx.
Cesar Aracena
caracena@infovia.com.ar
Neuquen, Argentina