Re: Group and count at the same time?

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 =".$genre; $query = mysql_fetch_row($sql); // echo the results echo "You have $query ablums that are $genre<BR>"; } Thats just off top top of my head so it may or may not work. Adam On Thu, 15 Aug 2002, 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 > > 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 > > >