select top 5 clients with most calls logged

[shocker-z]

Hi,

 

I'm at a dead brainer again!

 

What i need to do is select the top 5 client who have the most reccords in my database

 

so im guessing im going to have to group them to return how many clients are selected.

 

i was thinking somthing like

 

SELECT client FROM pronet

WHERE logged BETWEEN '$monthstart' AND '$monthend'

GROUP BY client

LIMIT 5

 

would work but it's not returning the top 5 highest.. also i could do with retuirning the number of calls in the database too.

 

 

Regards

Liam

[per1os]

SELECT COUNT(client) as ClientCount, client FROM pronet
                     WHERE logged BETWEEN '$monthstart' AND '$monthend'
                     GROUP BY client
                     ORDER BY ClientCount
                     LIMIT 5

 

Untested and not sure if it will work, but give it a shot.

[shocker-z]

$gettoploggedclients=mysql_query("SELECT client, count(*) as `clientcount` FROM pronet

WHERE logged BETWEEN '$monthstart' AND '$monthend'

GROUP BY client

ORDER BY clientcount DESC

LIMIT 5") or die('Error getting top logged clients: '.mysql_error());

 

that works just figured it myself

 

thanks anyway mate