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]
