Re: counting of values in one field possible with one sql statement?
| From: | DL Neil | Date: | Fri, 08 Mar 2002 00:42:15 +0000 |
| Subject: | Re: counting of values in one field possible with one sql statement? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17559@lists.php.net to get a copy of this message | ||
Hi Andy,
> I am wondering if it would be possible to get the amount of different
values
> in one sql command.
> E.g.:
> field age: 0,3,5,5,2,3
>
> Sql querry should return how often 3 occurs. Which would be 2. And as
well
> the other values... 1 for agestructure 2 becuase it occures only once.
>
> I wrote following querry
>
> $stmt="
> SELECT COUNT(*) AS c
> FROM $T5
> WHERE age = 4
> ";
> $row = db_get_row2($stmt);
> $age_4 = $row->c;
>
> This returns only the value for 4. To get all values (10 different
ones) I
> would have to make 10 querrys, right?
>
> Is there a faster way?
SELECT
COUNT( IF( age = 0, 1, 0 ) ) AS Infants,
COUNT( IF( age = 1, 1, 0 ) ) AS One,
COUNT( IF( age = 2, 1, 0 ) ) AS Two,
...
FROM $T5;
but at this time of night, shouldn't you be counting sheep?
=dn