Re: Sum from Arrays ?

Try this: for($i=0;$i < count($the_array); $i++)

    $sum = $sum + $the_array[$i];

or if the index of your array is not in order, try this: while($element = array_pop($the_array))

     $sum = $sum + $element;

Hope that helps. Rdb At 06:38 PM 2/7/01 +0100, you wrote:

No I've explained this badly I've got the array $a what I want is a sum of what's in the array ie from your sample the answer would be 1+3+5 = 9 Thanks Keith Hum, maybe the count() function. Works with mysql_fetch_array() too. Here's a sample: $a[0] = 1; $a[1] = 3; $a[2] = 5; $result = count ($a); //$result == 3 Here's a link: http://php.net/manual/en/function.count.php DISCLAIMER: I am by no means well-versed in this, or any other, topic.... - Shane ----- Original Message ----- From: "Keith Whyman" <k.whyman@bf-72.de> To: <php-general@lists.php.net> Sent: Wednesday, February 07, 2001 12:15 PM Subject: [PHP] Sum from Arrays ?

It's probably a stupid question but........... I've got the following ; SELECT t_category_name COUNT(*) AS count FROM t_city,t_zipcodecity,t_location,t_category , t_locationcategory WHERE (t_category_id_category = t_locationcategory_id_category) AND (t_location_id_location = t_locationcategory_id_location) AND (t_zipcodecity_zipcode = t_location_zipcode) AND (t_city_id_city = t_zipcodecity_id_city) AND (t_city_id_city = 1) AND ((t_location_sex = 4) OR (t_location_sex = 0)) GROUP BY t_category_name"; $result1 = mysql_db_query(DBWEB, $query); print mysql_error(); echo " <TABLE width=\"100%\"> "; if ($result1) {

        while ($r = mysql_fetch_array($result1)) {
            $numbers = $r["count"];
            $names =$r["$t_category_name"];

And what I want is a total for my count - I think it something to do

with

the mySQL sum funktion but I've got a bit stuck ! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ "God is the unrestricted act of understanding, the eternal rapture glimpsed in every Archimedean cry of Eureka."

                        - Bernard Lonergan -

~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^ Reuben Donald Budiardja reubendb@goshen.edu Homepage: http://www.goshen.edu/~reubendb