6 replies to this topic

[Marxx]

Hi all! I have this problem whit SQL data and how to count them..
Well, here's example:

ID=1 Name=Apples Stored=32
ID=2 Name=Bananas Stored=16
ID=3 Name=Oranges Stored=132

How can I count all Stored amount together? So the Stored amount should be 180
I've tryed this:

$showcount = mysql_query("SELECT Stored FROM fruits");
while($count = mysql_fetch_row($showcount)) {
$counted = $count[0] + $count[0]

echo $counted;
}

But no luck.. :/
Can someone help me whit this please..


Thanks for all!

[Demonslay]

$showcount = mysql_query("SELECT Stored FROM fruits") or die(mysql_error());
$counted = 0;
while($count = mysql_fetch_row($showcount))
  $counted += $count[0];

echo $counted;

Simple.

[bay]

use SUM() in your query:

$query = mysql_query( "SELECT SUM(Stored) AS totalStored FROM fruits" );
$fetch = mysql_fetch_assoc ( $query );
$totalStored = $fetch['totalStored'];

[Demonslay]

Or you could do that, lol, I wasn't quite sure SUM() was a real function, but I finally found it on the development site.

[bay]

Demonslay, on Jul 15 2007, 03:41 PM, said:

Or you could do that, lol, I wasn't quite sure SUM() was a real function, but I finally found it on the development site.

yeah, its a function. MySQL is very powerful, a lot of people add a lot of excess PHP code when they try to sort out there results when in reality they can let MySQL do everything for them.

[Marxx]

Wow ... Thanks guys! Both ways are nice but bays is way simple!

Thanks for fast reply!

[bay]

your welcome