Need a little help with a query

[Vizonz]

 

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

[dabaR]

SELECT player, SUM(goals) FROM match_stats WHERE player = 'dabaR';

 

Maybe you can modify that to your situation.

[Vizonz]

the where part is what messes me up. i want to get the total

 

of songs played by artist. and show a top 10 of the artists

[dabaR]

Try:

SELECT songlist.artist, SUM(songlist.count_played)
FROM
  radio.songlist
GROUP BY songlist.artist
ORDER BY
  SUM(songlist.count_played) DESC
LIMIT 10

[Vizonz]

thats exactly it thanks so much i been  driving my self crazy trying to figure it out

[dabaR]

You're welcome.

[Vizonz]

the only problem now is when i try to put php to it it leaves that count played field blank ?  when i run the query it shows the results but is there something i need to do different to show that sum with php ?>

[dabaR]

Try:

 

SELECT songlist.artist, SUM(songlist.count_played) AS count_played
FROM
  radio.songlist
GROUP BY songlist.artist
ORDER BY
  SUM(songlist.count_played) DESC
LIMIT 10

[Vizonz]

there we go perfect   thanks again much appreciated