[SOLVED] select distinct count() problem

[Panjabel]

Hello

i have table members with many users and comments

i want to select unique users and order them by number of comments

select distinct(userid) from members order by count(comments) desc

the command will display the same users many times, not unique users.

what's wrong in the query ?

[jlp09550]

So, you just want to show the different usernames like this:

 

Username1

Username2

Username3

 

.. instead of:

 

Username1

Username1

Username2

Username3

Username3?

 

If so, try (not sure if it would work, but you can try):

 

select distinct(userid) from members order by count(comments) group by userid desc

[Panjabel]

doesn't work

[jlp09550]

doesn't work

 

Hmm. Well, for my users online script, I had to group the usernames because they would show up more than once if someone has a [very] dynamic IP, like AOL.

 

The query I used:

SELECT `username` FROM `users_online` GROUP BY `username` ORDER BY `lastvisit` DESC

 

Might help a bit if you would understand that.

But it does indeed work on this side.