[Highest 10]

I've been dealing with this for a while now...

 

I got a site where people can rate websites...

If you rate a website it is put in the db like this...

Database name is Rating

Rating_id

Website_id

User_id

Rating

 

Now I need to get the 10 highest scores...

The problem is that the user_id can be in the db several times...

If got like 5 times user id 5 in it...

How can I select the user_id's just once... so that I won't get 5 times the same user_id

 

I hope I made some sense... and i hope someone can help me with this...

if somethings unclear I'll try and explain it beter

[sorry]

sorry for this... put it in the wrong thread...