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