Problem with DISTINCT() and multiple columns

[sw0o0sh]

I have a table called RSCD_TRAPS (it's for a game).

The columns are as follows:

id, user, time, ip, details

 

I'm trying to do this query, (in combination with PHP):

SELECT DISTINCT(user),id,time,details FROM rscd_traps

 

However, it still will call non-distinct results for user. What am I doing wrong? I'm trying to basically fetch DISTINCT(user), and the corresponding columns that go along with it, however it ends up fetching the entire thing. Is there anyway to do this in 1 query?

[Mchl]

DISTINCT is not a function. It's a query modifier, that tells MySQL to return only distinct rows (always taking all columns into consideration).

[kickstart]

Hi

 

Further to the above, is user unique on that table? If so then you do not need any way to pull a distinct row, if now then how do you want MySQL to determine the row to retrieve the other fields from?

 

All the best

 

Keith