MySQL Query - 选择distinct显示错误的结果

Question

Im wondering if someone could help me.

I have hundreds of people uploading images to my site, basically each upload has its own row in the database with the data created, user id, images name etc etc etc.

What i want to do is display the last 3 users to upload images the problem being that if a user uploads more pics, another row is added to the database with that users id so i can just show the last 3 rows.

I have the following statement, but it doesnt seem to be working properly

SELECT DISTINCT * FROM kicks GROUP BY uid ORDER BY created DESC LIMIT 3

I was wondering if someone could point me out where im going wrong.

Cheers

Sorry, i should have added sample data, ok

id | uid | created |

195 | 33 | 2012-03-06 12:32:54
196 | 33 | 2012-03-06 12:35:23
197 | 34 | 2012-03-06 13:09:31
198 | 19 | 2012-03-08 10:37:21
199 | 33 | 2012-03-09 21:04:04

Answer 1

SELECT DISTINCT uid FROM kicks ORDER BY created DESC LIMIT 3 is what you want.