Problem with the DISTINCT command

[Anon]

I´m getting really confused with the distinct command, help would be appreciated.

This is what I would like to use:

"SELECT DISTINCT username, date_format(time, '%M, %D, %r') AS times FROM logins ORDER BY time DESC LIMIT 10"

But it just returns errors.

"SELECT DISTINCT username FROM logins"
and
"SELECT *, date_format(time, '%M, %D, %r') AS times FROM logins ORDER BY time DESC LIMIT 10"

works fine, but not my combo, any ideas ?

[Anon]

Looks like it should work. What happens if you take off the ORDER BY and LIMIT part?