Counting....

[karlblau]

Hi!

I have a db with the following structure

Db name: virus
table name : Elof

And fields

Id - Source - Nmbr - Date

---

I basicly want to ask the database to give me
all the rows within a time spec...
So the code i wrote fast looks like this

<?

$open = mysql_connect("localhost", "root", "") or die ("not posible to connect to server");

$data = mysql_db_query("virus", "SELECT * FROM elof WHERE date LIKE '2003-10-10 13:40%' ORDER BY date");

while ($rad = mysql_fetch_array($data)) {

echo $rad["nmbr"]. "<br>";

}

?>

This code will give and output that looks like this:

22
6
42
18
62
3
53
47
27
2
6
3
2
3

I basicly want to add all these vallues together, but i have no clue
at all how to do it.. All the tests i have done has failed..
Have anyone got a clue how to do it??? i bet its werry simple
but i just dont know how...

[laserlight]

Should be trivial, just add them up:

<?php

$open = mysql_connect("localhost", "root", "") or die ("not posible to connect to server");
$data = mysql_db_query("virus", "SELECT * FROM elof WHERE date LIKE '2003-10-10 13:40%' ORDER BY date");

$sum = 0;
while ($rad = mysql_fetch_array($data)) {
	$sum += $rad["nmbr"];
}
echo $sum;

?>

You can also use an SQL statement to select as a sum, but you'll have to look that up in the appropriate docs.

[BuzzLY]

If all you want is the sum of those values, then use the SQL statement:

SELECT SUM(nmbr) FROM elof WHERE date LIKE '2003-10-10 13:40%' GROUP BY nmbr

Your result set should contain one row, and $row[0] will contain your sum.

However, if you want the other values in the table as well, you'll need to use your query and add the column values as laserlight showed you.

If your result set has 500,000 rows, however, you may want to run the above SQL query instead of looping through your result set and adding. I'm not sure how long each method would take -- they are both valid methods, and it just depends on how fast you want it to be, and how scalable.