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 an
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|
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 f
You could do it if you had a table with each genre of music.
// get each genre
while ($genre = mysql_fetch_array(mysql_query(select * from genre_table));
{
// sql query to fetch the # of albums of a specific genre
$sql = mysql_query(select count($genre) as count from album_table where
genre =".$g
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)
countr
5 matches
Mail list logo