Re: Group and count at the same time?
| From: | (Dan Tappin) | Date: | Thu, 15 Aug 2002 15:37:14 +0000 |
| Subject: | Re: Group and count at the same time? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-112777@lists.php.net to get a copy of this message | ||
I think you want something like this:
SELECT genre, COUNT(*) as count FROM music GROUP BY genre;
Dan
> I am using PHP to maintain a catalog of music and have been just fine with
> it but have run into one thing i want to do and need some advice.
>
> The format of the data is like so:
>
> upc|genre|distributor|details
>
> What I want to do is grab a "summary". So it would end up printing out:
>
> rock (43)
> country (41)
>
> and so on. Is this possible to do with one query or will I need to do it
> with more? So I want to count the number of each genre and provide a count
> for each.
>
> Jeff