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" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> >
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
"God is the unrestricted act of understanding, the eternal rapture
glimpsed in every Archimedean cry of Eureka."
- Bernard Lonergan -
~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^
Reuben Donald Budiardja
[EMAIL PROTECTED]
Homepage: http://www.goshen.edu/~reubendb
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
