[SOLVED] Php - Mysql Help. Calculate most active user based on num. of matching rows?

[itsureboy]

Okay, so what I'm trying to do is to calculate the number activities (rows) users have made in a table I call, lets say, ACTIVITIES in the last 24hrs.

 

I then want to select the ID of the user that has had the most activity in the last 24hrs, however without selecting all of his activities and each of those rows information, because the table activities is mainly for the purpose of determining the most active user (by the amount of rows selected with his matching userid/ sort of a mode type thing) and select their userid based on that.

 

Can anybody tell me a way or what I can use to accomplish this? Or it its even possible?

 

I don't need help with any timing or anything like that, just a way.

 

Hope this makes sense, kinda rushed through it, a little frustrated.

 

Thanks ahead..... 

 

[VirtualOdin]

Try "count() where userid='[userid]' "

[itsureboy]

Thanks...

 

 

But the problem with using that is that it will simply just count the rows of a specific user. I need to count the rows of all users and then select the id of the one with the highest count.

[trq]

I have asked for this question to be moved to our mysql help board.

 

SELECT id, COUNT(id) AS cnt FROM users ORDER BY cnt DESC LIMIT 1

[itsureboy]

Oh, sorry, didn't notice, I've been doing so much PHP its all i see..

 

But thanks, that looks like it'll work! let me test it out. thanks alot!