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.


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

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to