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]
