Jump to content

Need a little help with a query


Vizonz

Recommended Posts

 

SELECT DISTINCT
  songlist.count_played, songlist.ID, songlist.artist
FROM
  radio.songlist
ORDER BY
  songlist.count_played DESC

is generating a list

 

now how can i merge artists together and get the total out of all the count_played ?

if i group it by artist it just shows me the top record.

 

which is 24 but when not grouped there is  three records..

 

one is 24  one is 20 and one is 12

totalling 56

Link to comment
https://forums.phpfreaks.com/topic/206101-need-a-little-help-with-a-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.