Jason,
Much appreciated, this worked :)
select genre, count('genre') from catalog group by genre
----- Original Message -----
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 15, 2002 11:26 AM
Subject: Re: [PHP] Group and count at the same time?
> On Thursday 15 August 2002 23:19, Jeff Lewis wrote:
> > 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
>
> Where is this info coming from?
>
> > 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.
>
> If it's from a database then you really should be asking on the php-db
list.
>
> Something like:
>
> select genre, count('genre') from catalog group by genre
>
> should work.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
