MySQL Query; Counting and adding values

ReSpawN · 12-11-2007, 02:09 PM

I myself find this a little bit disturbing. It sounds so easy, so practical and so common to use, but I can't seem to grasp it. Not even FIND OUT how it works. Thats why this kinda belongs in the "Absolute Beginners" board. :P

I want to add values, for example I've got a table layout:

PHP Code:


			
    id--    itemname--    itemcosts--

    1        item1            1

    2        item2            7

    3        item3            2

Adding the values itemcosts in a for/foreach/while loop will result in the integer 10. The point is, I want this done WITHOUT a loop of any kind. I want the mySQL Query to do the work for me. I've conciddered the COUNT option but else it's all a blank.

So, in 1 query, lets say $fCount, I want to get the integer 10.

Can anyone help me out here? :)

Village Idiot · 12-11-2007, 03:00 PM

If you are displaying the data, you have to use a loop. Just add the costs while you are displaying them and print them after the loop.

If you want it from just a query,

PHP Code:


			
SELECT SUM(itemcosts) AS fCount FROM table WHERE 1;

That will add all the values of field and assign it to total. Now just use this to print it

PHP Code:


			
$query = mysql_query("SELECT SUM(itemcosts) AS fCount FROM table WHERE 1;");
$result = mysql_fetch_array($query);
$fCount = $result["fCount"];

ReSpawN · 12-11-2007, 03:18 PM

Wow, that simple huh. A mate of mine knew that there was a simple word for it but that ... I myself was thinking about ADDING numbers, which forms SUM a couple of numbers. Simply couldn't think of the word.

Thanks Village.

Lock? :)

SOCK · 12-11-2007, 10:07 PM

FYI - there is a huge index of MySQL functions available in the online MySQL Manual.